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
Mala Studentska sve
h
My data
Left join producing wrong result
db_hotelc
Task_3_FInal
SQL flight 2
sql
second Query
sql