>>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.