Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
do several updates at once
select id,sta into #tmp from ( select 60000 id,9 sta union all select 61000,8 union all select 61209,7 union all select 61208,6 union all select 72000,5 union all select 72670,10 union all select 56916,11 union all select 55451,12 ) tbl; select * from #tmp; -- before update #tmp set sta=st from ( select 61209 i,2 st union all select 61208,2 union all select 72670,3 union all select 56916,3 union all select 55451,4 ) tv inner join #tmp on id=i; select * from #tmp; -- after
run
|
edit
|
history
|
help
0
STACK
Stackoverflow 37635278
create table with constraunt
Elena-Tests
count events by 2 shift cycles using derived table
test
1
sql server dynamic 12 month time series and pivot with month year column names
28-02
Turn column into string