select parent.Pid,parent.Pname,parent.Pemail,child.Cname from parent right outer join child ON parent.Pid= child.Pid where parent.Pid=2
select * from ( select val, Cid,Item from child unpivot ( val for Item in (Cname) )u ) x pivot ( max(val) for Cid in ([1], [2], [3], [4], [5], [6],[7], [8], [9], [10], [11], [12],[13]) ) p
Select Parent.Pid,Parent.Pname,Parent.Pemail, Left(Main.Child,Len(Main.Child)-1) As "ChildValues" From(Select distinct Child2.SubjectID, (Select Child1.Cname AS [text()] From dbo.Child Child1 Where Child1.Pid = Child2.Pid ORDER BY Child1.Pid For XML PATH ('')) [Child] From dbo.Child Child2) [Main]
PIVOT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)