Skip to content
Advertisement

how do I split one row to two rows based on column value

my input is :

And i am expecting below output:

I tried using cross apply but not getting right output. Can anyone please help me?

Advertisement

Answer

UNION is the right way to solve this:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement