|
nr
SQLTeam MVY
United Kingdom
12543 Posts |
 Posted - 03/16/2001 : 11:29:12
|
Would probably be better (and easier) to do this with temp table but without something like.
insert NewTbl
select ID, Name, Type
from Table1
where convert(varchar(10),id) + Name + Type
in (select min(convert(varchar(10),id) + Name + Type) from Table1 group by id)
while @@rowcount > 0
begin
update NewTable
set Name = Name + ';' + Table1.Name,
Type = Type + Table1.Type
from Table1
where convert(varchar(10),Table1.id) + Table1.Name + Table1.Type in (select min(convert(varchar(10),id) + Name + Type) from Table1 where convert(varchar(10),Table1.id) + Table1.Name + Table1.Type > convert(varchar(10),NewTable.id) + right(NewTable.Name,1) + right(NewTable.Type,1) group by id)
|
 |
|
Mutivalue in table by using TSQL/Store Procedure
