PIVOT A TABLE IN SQL [login to view URL] the sql code.
See Attach file.
7 freelancere byder i gennemsnit ₹1014 på dette job
Hi I have create the TestDB on my PC. But there are 5 columns in the table. I need more details about the result you want. please contact me for further discussion!
I have been working on MS SQL Server for more than 6 years. I am a software developer and an expert in sql. I believe in providing on time quality work to client. I can provide you query on pivoting the table.
Table looks relatively and I am assuming you need subject names as columns and remaining data in rows. Let me know if you need it as dynamic or just for this table and constant number of subject names.