Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Quaffer
Starting Member
1 Post |
 Posted - 2007-10-12 : 22:02:32
|
| HelloI need some help/guidence with a SQL 2000 view I have been requested to writeThe table structure is [DateTime].........[SEQNO]...[Text]2007-10-10.12.59.21 1 This is line 12007-10-10.12.59.21 2 This is line 22007-10-10.12.59.21 3 This is line 32007-10-10.13.01.02 1 This is line 1The view is required to return the DateTime once and all the text joined where the DateTime is the same i.e[DateTime]...............[Text]2007-10-10-12.59.21 This is line 1 This is line2 This is line 3Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-12 : 23:00:34
|
| For SQL 2000, you can use a CSV function (use a space as the separator rather than comma):http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19647For 2005, use the method shown in BOL as mentioned in the second to last post in that thread.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Add specific columns in a View