Home Forums Article Discussions Article Discussions by Author Discuss content posted by Suresh G. Kumar A simple T-SQL statement to create a list of lookup values RE: A simple T-SQL statement to create a list of lookup values

  • March 21, 2011 at 12:54 am

    #1301123

    It can be made simple with the following sql statement

    SELECT REPLACE((SELECT DISTINCT RTRIM(LTRIM(StatusDesc)) AS 'data()'

    FROM dbo.MyStatus

    FOR XML PATH ( '' )), ' ', ', ')