Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Co-Related sub query
create table #tmp(roleid int,comid varchar) insert into #tmp values(1,'A'),(1,'B'),(2,'C'),(2,'D') select * from #tmp SELECT roleid, comid= STUFF((SELECT ', ' + comid FROM #tmp r where r.roleid=t.roleid FOR XML PATH('')), 1, 2, '') FROM #tmp t GROUP BY roleid SELECT ', ' + comid FROM #tmp r FOR XML PATH('') drop table #tmp
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
SQL_Joins_Intersect_Except_Union
forming date as nvarchar
SQL query to find difference in text between different rows
Stuff code in sql
SQL2
TEST 1
Sundays in 2017
Shalvika's Query
Query to remove the string between two indexes of delimiters
Try_Parse (Type Casting )
stackse - search stackoverflow differently
Please log in to post a comment.