Home > SQL Server > Select Multiple Rows in One Row SQL Server

Select Multiple Rows in One Row SQL Server


Hi all,

try this example to combine multiple rows into one


declare @Table Table
(
[Numbers] varchar(40)
)
INSERT INTO @Table VALUES('One');
INSERT INTO @Table VALUES('Two');
INSERT INTO @Table VALUES('Three');
INSERT INTO @Table VALUES('Four');
INSERT INTO @Table VALUES('Five');

-- Query to combine multiple rows into one
DECLARE @str VARCHAR(100)
SELECT @str = COALESCE(@str + '|', '') + [Numbers]
FROM @Table
Print @str

Hope this helps

Good Luck

Advertisements
Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: