timgaunt/gist:de0768cb09f634ba8c98

Created June 23, 2014 15:54

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/timgaunt/de0768cb09f634ba8c98.js"></script>
Save timgaunt/de0768cb09f634ba8c98 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

gistfile1.sql

	DECLARE @S varchar(max) = ''
	SELECT @S = @S + '
	' + [YourField] FROM [YourTable]

	SELECT @S AS [Data] FOR XML PATH('')

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