Concatenate two Column with comma seperated

Question

Please Help me to find the Query I want to Concatenate Column1 and To column2 with comma seperated Output like this... 9-105-5-690-100100-200

Imtiyaz Ansari · Answer

Hi Imran Try This ... CREATE TABLE [dbo].[Test]( [Name] [varchar](50) NULL [Name1] [varchar](50) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO INSERT [dbo].[Test] ([Name] [Name1]) VALUES (N'1' N'5') GO INSERT [dbo].[Test] ([Name] [Name1]) VALUES (N'2' N'10') GO INSERT [dbo].[Test] ([Name] [Name1]) VALUES (N'3' N'15') GO --//==============Select ========================= DECLARE @ConcatString VARCHAR(4000) SELECT @ConcatString = COALESCE(@ConcatString + ' ' '') + Name +'-'+ Name1 FROM Test SELECT @ConcatString AS Test GO --==========================================

pritaeas · Answer

You mean like this? SELECT CONCAT([From] '-' [To]) FROM YourTable

Imtiyaz Ansari · Answer

Welcome...........!!!

imran azam · Answer

Thank Imtiyaz bhai... i got my answer. using your code and minor changes... DECLARE @ConcatString VARCHAR(4000) SELECT @ConcatString = COALESCE(@ConcatString + ' ' '') + Concat(Name'-' Name1) FROM Test SELECT @ConcatString AS Test GO Thanks a Lot.

imran azam · Answer

yes i want like this but in comma seperated... Output like this... 9-105-5-690-100100-200 Because these number From and To are related with some Package id. So i want to update all data in another table column like 9-105-5-690-100100-200