Get a comma separated string

DECLARE @strCommaSeperated VARCHAR(MAX)
–Make comma seperated values from a column
SET @strCommaSeperated =
SUBSTRING((SELECT ‘,”’+ s.EntityName+”” FROM dbo.Entity s FOR XML PATH(”)),2,20000)
SELECT @strCommaSeperated

Selecting Comma Separated orderID from OrderDetails Table

DECLARE @MyOrderList VARCHAR(MAX);
SET @MyOrderList = ”
SELECT @MyOrderList = ISNULL(@MyOrderList ,”) + OrderNO + ‘,’ FROM OrderDetails

SET @MyOrderList = SUBSTRING(@MyOrderList , 1, LEN(@MyOrderList )-1)
SELECT @MyOrderList

Advertisements

About Gokul Dahal, Nepal

Software Engineer, Freelancer, Design and Develop web applications,Software Developer Nepal, FreeLancer Nepal Contact : gokuldahal@gmail.com
This entry was posted in SQL and tagged , , , . Bookmark the permalink.

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