Combining Fields

Transact-SQL
4

You can do this with UNPIVOT:

Declare @T Table
(
	Id int identity(1,1),
	First_Value Int,
	Second_Value Int
)

insert into @T values (55,10),(65,70)

select * from @t
unpivot (
	[values] for [type] in (First_Value,Second_Value)
)UPVT
1 Like