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

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

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


About Gokul Dahal, Nepal

Software Engineer, Freelancer, Design and Develop web applications,Software Developer Nepal, FreeLancer Nepal Contact :
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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s