how to change column into row in sql

Answer Posted / vishal

with the help of pivoting....
it will solve the problem of grouping also

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the on update no action do?

757


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2368


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1413


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

806


What happens on checkpoint?

772






Where can you find the error log information? : sql server database administration

739


How many columns can exist together per table?

882


What are translations and its use? : sql server analysis services, ssas

792


Show Practically Sql Server Views are updatable?

780


what are isolation levels? : Sql server database administration

657


What is factless fact table? : sql server analysis services, ssas

758


How can I tell if sql server is 32 or 64 bit?

705


Explain following error properties?

725


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2032


What is molap and its advantage? : sql server analysis services, ssas

706