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