Post reply

Return Column as List of Comma Seperated Values

  • December 30, 2009 at 6:48 am

    #1097404

    A simple script to get comma seperated result. 😎

    declare @empids varchar(max);

    set @empids = '';

    select @empids = convert(varchar, empid) + ', ' + @empids

    FROM employee

    select @empids

    --output

    --, 1 , 2, 3 , 4

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply