How to change rows into column and columns in to rows using sql query in MSSQL?

  • Interview Candidate
  • 6
  • 2633

Showing Answers 1 - 6 of 6 Answers

jjvetri

  • May 8th, 2009
 

CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions