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 1:08 am

    #1301127

    Yo can also write example like this:

    DECLARE @MyStatusList VARCHAR(1000)

    SELECT @MyStatusList = COALESCE(@MyStatusList + ',', '') + StatusDesc FROM MyStatus

    select @MyStatusList