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 3:17 am

    #1301151

    arty 15255 (3/21/2011)

    In regards distinct values:

    SELECT @s-2 = ISNULL(@s+',','')+field FROM dbo.TABLE

    GROUP BY field

    works well too.

    I forgot to mention that ORDER BY field works as well 🙂