>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.