aliprogrammer69/Concat.sql

Created October 25, 2016 12:52

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

Select an option

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

Download ZIP

How to concat one cloumn of N Rows To One Column in sql server

Raw

	SELECT STUFF((SELECT ',' + Username
	FROM UserMgmt.[User]
	FOR XML PATH('p'), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,'')

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