Insert from select on same table and store old and new identity values in separate table, Sql Server

Insert from select on same table and store old and new identity values...

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 9, rows affected: 6, absolute service time: 0,17 sec

edit mode | history

  
SolutionID
SolutionName
ClientNumber

1
1
solution1
111

2
2
solution2
111

3
3
solution3
111

4
4
solution1
111

5
5
solution2
111

6
6
solution3
111


  
newSolutionID
oldSolutionID

1
4
1

2
5
2

3
6
3

λ

                                      .NET NoSQL database for rapid development