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 MorePosted Nov 30, 2011, 2:16 AM
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 GaradPosted Nov 30, 2011, 2:13 AM
DECLARE @test NVARCHAR(max)
SELECT @test = COALESCE(@test + ',', '') +Col1+'/'+ Col2 FROM
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 RPosted Nov 30, 2011, 2:35 AM
Krishna GaradPosted Nov 30, 2011, 2:16 AM
DECLARE @test NVARCHAR(max)
SELECT @test = COALESCE(@test + ',', '') +Col1+'/'+ Col2 FROM Tblxyz Where Col1='1234' SELECT col1= @test