Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Demo
CREATE TABLE #Table1 (datekey int, pointkey int, filter_key varchar(4), t_key int) ; INSERT INTO #Table1 (datekey,pointkey, filter_key, t_key) VALUES (5506061, 37, NULL, 1), (5506061, 37, NULL, 1), (5506061, 37, NULL, 1), (5506061, 37, NULL, 1), (5506061, 37, NULL, 1), (5506061, 37, NULL, 1), (5506763, 37, NULL, 2), (5506763, 37, NULL, 2), (5506763, 37, NULL, 2) ; ;with cte as ( SELECT datekey, pointkey, filter_key, CASE WHEN t_key = 1 AND Row_number()OVER(ORDER BY t_key) = 1 THEN 1 ELSE 2 END AS new_filter_key, t_key FROM #Table1 ) update cte set filter_key = new_filter_key select * from #table1
run
|
edit
|
history
|
help
0
MyWall
28-02
New
M0413045.sql
MERGE WITH OUTPUT
Negociosj
Names
Task_6_Final
Training1
Admno