Hi,
I have one senario. I have to merge more than one row into a single row.
I also found a solution. But i wanted to know is there any other way to do the same task ?
My approach is :
create table #t1
(
no char(1)
)
insert into #t1
select '1'
union
select '2'
union
select '3'
union
select '4'
Declare @no varchar(25)
select @no = ''
select @no = @no + no
from #t1
select @no
Inputs are welcome !