How to ouput in single row in sql server

Question

select mainline+'/'+subline from table1 where mainline='54326'

Here I m getting output like this

o/p:

Mainline

54326/1

54326/2

the above query i m getting output in two line

but i need an single line output like i mentioned below

Mainline

54326/1, 54326/2

anybody please post solution for this.....

Pravin More · Answer

Hi Rajkumar its possible do it like this.... declare @data varchar(max) SELECT @data = COALESCE(@data + ' ' '') + mainline+'/'+subline from table1 where mainline='54326' select @data execute above query Thanks Pravin.

Krishna Garad · Answer

Try This DECLARE @test NVARCHAR(max) SELECT @test = COALESCE(@test + '' '') +Col1+'/'+ Col2 FROM SELECT col1= @test in my case o/p is like as you expeting you can write like Declare @test Nvarchar(max) Select @test=COALESCE)@test+'')+MainLine+'/'+SubLine From Table Select Mainline=@test

Rajkumar R · Answer

thanks a lot Krishna Garad and Pravin More

Krishna Garad · Answer

you can use where clause also like DECLARE @test NVARCHAR(max) SELECT @test = COALESCE(@test + '' '') +Col1+'/'+ Col2 FROM Tblxyz Where Col1='1234' SELECT col1= @test