Saturday, 20 October 2012

select row as column in sql server


DECLARE @strValues varchar(8000)
 SELECT @strValues = COALESCE(@strValues+',', '') + MainID
FROM
(
    SELECT   MainID
    FROM EndUser
) X
ORDER BY MainID


select @strValues

No comments:

Post a Comment