IT Solution
For Any Problem Their is Always Exist a Solution only U Have To Find
Monday, 2 January 2012
Concatenation of multiple rows of single column as a single data(row)
select Classcode,Classname,
(select subject from ClassSubjectList+',' as 'data()' from ClassSubject for xml path('')) as subject
from Class
where Classcode='LKG'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment