declare @tbla table(keyid int , field1 char(1) ,field2 char(1) ,field3 char(1),field4 char(1),field5 char(1) )
insert into @tbla values (1,'a','b','c','d','e')
declare @tblnum table (number int)
insert into @tblnum values (1)
insert into @tblnum values (2)
insert into @tblnum values (3)
insert into @tblnum values (4)
insert into @tblnum values (5)
select keyid,
case number
when 1 then field1
when 2 then field2
when 3 then field3
when 4 then field4
when 5 then field5
end
from @tblnum cross join @tbla
M A Srinivas
M A Srinivas