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
While Loop in SQL Server for Multiple Entries
new
Datos relacional BRYAN
FIGURA5.1
Cte recursion
MSSQL NVARCHAR to INT conversions
Outer Apply successer cell chek and get the result
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3
Exam_1_Final
new