Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
StackOverflow_53753663
CREATE TABLE myTable (id int, idnew int) ; INSERT INTO myTable (id, idnew) VALUES (1, 2), (3, 4), (2, NULL), (4, 7), (6, 8), (7, NULL) ; SELECT * FROM myTable; SELECT mixed_id FROM ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS row_num, id, idnew FROM myTable ) AS x UNPIVOT ( mixed_id for item in (id, idnew) ) AS y WHERE mixed_id IS NOT NULL ORDER BY row_num, mixed_id ;
run
|
edit
|
history
|
help
0
SQL Server : Calculate Going Step (Yutthana Thanomklay)
Libros
food_plan
SQL Server - Multiple Holidays Model
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql
repert
samplequery
http://connect.bein.net/ar/live-ar/
sql 7
VANYA