Hi
I have 3 tables Books,Student,Issue Table. Issue table has BookId,StudeutId, Books Issued
I want data to appear like below
Child1 Child2 Child3 Child4
Book1 2 4
Book2 1 5
Thanks
Loading
Hi
I have 3 tables Books,Student,Issue Table. Issue table has BookId,StudeutId, Books Issued
I want data to appear like below
Child1 Child2 Child3 Child4
Book1 2 4
Book2 1 5
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
PhamNgoc KhiemPosted Jul 12, 2022, 8:12 AM
You can see this link to how to using pivot
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16