row to column

Question

Post reply

row to column

jmari75

Grasshopper

Points: 11
More actions
July 22, 2010 at 1:06 am

#224453

My table have following format
Table ID Entry No.Dimension Code Dimension Value Code
330000771812707BRANCH 1201010
330000771812707DEPT 182310
330000771812707EMP 7058
330000771812707SBU 18
330000771812721BRANCH 2202020
330000771812721DEPT 100020
330000771812721EMP 7079
330000771812721SBU 10
i want to convert like this
Table ID Entry No. SBU BRANCH DEPTEMP
3300007718127071812010101823107058
3300007718127211022020201000207079
pls give the query for the same
regards
mariyappan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 1

hi,

Use Pivot query ...

see the below link....which gives more details....

http://www.mssqltips.com/tip.asp?tip=1019

Regards,

Chowdary

sql-programmers SSC-Addicted Points: 494 More actions · Answer 2

Using PIVOT .......

See this link .this will give you example Query......

Link:

http://www.sql-programmers.com/Blog/tabid/153/EntryId/6/Using-PIVOT-and-UNPIVOT.aspx

SQL Server Programmers and Consultants

http://www.sql-programmers.com/

SQL Sever Performance tuning

WayneS SSC Guru Points: 95460 More actions · Answer 3

As the others have already mentioned, you need to PIVOT your data. Take a look at the two Pivot/Cross-tab articles (Part 1 and Part 2) linked to in my signature.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2