Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select * , CASE
- when a > b THEN b = c
- when c > d THEN d = c
- when e > f THEN f = e
- when g > h THEN h = g
- when i > j THEN j = i
- when k > l THEN l = k
- when m > n THEN n = m
- when o > p THEN p = o
- END as value
- INTO #temptable
- From #atemptable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement