Labels

Apache Hadoop (3) ASP.NET (2) AWS S3 (2) Batch Script (3) BigQuery (21) BlobStorage (1) C# (3) Cloudera (1) Command (2) Data Model (3) Data Science (1) Django (1) Docker (1) ETL (7) Google Cloud (5) GPG (2) Hadoop (2) Hive (3) Luigi (1) MDX (21) Mongo (3) MYSQL (3) Pandas (1) Pentaho Data Integration (5) PentahoAdmin (13) Polybase (1) Postgres (1) PPS 2007 (2) Python (13) R Program (1) Redshift (3) SQL 2016 (2) SQL Error Fix (18) SQL Performance (1) SQL2012 (7) SQOOP (1) SSAS (20) SSH (1) SSIS (42) SSRS (17) T-SQL (75) Talend (3) Vagrant (1) Virtual Machine (2) WinSCP (1)

Wednesday, July 23, 2014

Insert a Comma Separator Between ResultSet of a SQL Table Column

Consider we have a table dbo.User, and we need to get all UserIDs separated by comma the apply below script:

Example:

Select Top 5 UserID From dbo.User

gives output as below

UserID
1
2
3
4
5

DECLARE @UserID VARCHAR(MAX)

SELECT @USERID = COALESCE(@USERID+',' , '') + UserID
FROM dbo.User
SELECT @USERID

This yields output as 1,2,3,4,5,....

No comments:

Post a Comment