>>I need to report in one string a list of value from a group by.
>>Ex:
>> SELECT Sort_Plan_Number
>> FROM dbo.StagingRollup
>> WHERE Valid_Status = -3300
>> GROUP BY Sort_Plan_Number
>>
>>I can use this select in a cursor and then fetch it but I think with SQL 2008 there is a better way.
>>Anyone know this one?
>
>
>DECLARE @test varchar(max)
>SELECT @test = ISNULL(@test+',','')+CAST(Sort_Plan_Number as varchar(200))
> FROM dbo.StagingRollup
>WHERE Valid_Status = -3300
>GROUP BY Sort_Plan_Number
>
>SELECT @Test
>
Actually, it will give you all groups. I guess I misunderstood the requirement.
If it's not broken, fix it until it is.
My Blog