chris-brown/comma-deliminate-rows

Created December 29, 2014 13:20

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/chris-brown/560464dd6ae980c8d41a.js"></script>
Save chris-brown/560464dd6ae980c8d41a to your computer and use it in GitHub Desktop.

Download ZIP

Comma deliminate a collection a data to a singe column

Raw

comma-deliminate-rows

	GO

	DECLARE @tableName VARCHAR(MAX)
	SELECT @tableName = COALESCE(@tableName + ',' ,'') + Name
	FROM sys.tables
	SELECT @tableName

	GO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment