How to make from one line, several ms sql?

W

WildJust2017-12-06 20:03:32

Transact SQL

WildJust, 2017-12-06 20:03:32

For example, there is an entry in the table
id task1 task2.........taskN
1 text1 text2.........textN
At the output I want to get
id numTask textTask
1 task1 text1
1 task2 text2
..... ...............................
1 taskN textN
Maybe it's easy and at the end of the day it doesn't cook, I'm waiting for help, the question is very urgent .

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Denis Holub, 2017-12-06
@WildJust

UNPIVOT