Get comma separated result – SQL

Posted: November 23, 2011 in SQLServer
Tags: ,

Declare @emps varchar(1000)
select @emps = COALESCE(@emps, ”) + ‘,’ + CAST(eid as varchar) from employee where firstname like ‘%vj%’
select ISNULL(substring(@emps,2,len(@emps)-1),”) Emps

Similar post …

http://www.codeproject.com/KB/database/Sql_Server.aspx?display=Print

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s