Unpivot not return null value?

Question

I want NULL value still in the output.

See below sample:

Declare @tbl table (id int, val1 int,val2 int,val3 int)
insert into @tbl values
(1,23,null,34),(2,16,74,25),(3,33,24,null)

select *
from @tbl
Unpivot(val for val_type in ([val1],[val2],[val3]))u

Answer 1

Hi @Siver

You could use Cross Apply like this:

SELECT id,C.*
FROM @tbl CROSS APPLY(VALUES(val1,'val1'),(val2,'val2'),(val3,'val3'))C(val,valtype)

Best regards,

Cosmog Hong