Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Joins outside XML element
create table #temp(cid int, val int) insert into #temp values (1,11), (2,12), (3,12) select t1.cid, xml = ( select t2.cid,t2.val from #temp t2 join #temp t1 on t2.cid = t1.cid for xml Path(''), type) from #temp t1 drop table #temp
run
|
edit
|
history
|
help
0
Dividing runs by time stamp
テスト2
SS mysqlsvr 2014 practice
Running Total
Add JSON"Valuetypes to XML Nodes using SQL
SQL HW 1 Appline
Creating tables in sql server
Practice
stackoverflow-54876809-trying-to-get-an-xml-file-into-sql-table
emp