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
SS my sql server 2014 4/7
text
Second Query
FIRST DATABASE
index fragmentation and how to deal with it
20181cse0065
Split name
string conversion
Many-to-Many Join Example
Transitive grouping with recursive sql