Thanks. It is a table with 50000 records. I know that I can do it quickly in VFP. Because the task seems quite simple I hoped that I can do it in an easy way in T-SQL.
>There's nothing built into TSQL to do this. If you're not dealing with a ton of data, it'll probably be easier to handle iteratively outside the database.
>
>-Mike
>
>>I have a table like this (on SQLServer) ?
>>
>>field1 (int) field2 (char)
>>1 aaa
>>1 bbbb
>>2 ccccc
>>2 bb
>>2 dd
>>2 hh
>>
>>How to get such results using T-SQL statment ?
>>
>>field1 'sum' of field2
>>1 aaa bbbb
>>2 ccccc bb dd hh
>>
>>
>>Thanks in advance
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only