Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Stuff code in sql
create table #temp (cid int, val1 int, val2 int, val3 int, val4 int) insert #temp values (1001,10,11,15,19), (1002,15,Null,16,18), (1003,14,18,15,NULL) SELECT distinct t2.cid, STUFF(( SELECT '' + REPLACE(t1.val1,'.','') + REPLACE(t1.val2,'.','') + REPLACE(t1.val3,'.','') + REPLACE(t1.val4,'.','') FROM #temp t1 WHERE t1.cid = t2.cid FOR XML PATH ('') ), 1, 1,'') as 'output' FROM #temp t2
run
|
edit
|
history
|
help
0
SQL Test
cms by valli
SQL Stringdata
bvbn
2021-03-09_LeetCodeSQL
abhishek
ms sql update,insert
stackoverflow_mysql_demo_data
RH
index fragmentation and how to deal with it