March 11, 2008 at 10:57 am
Dear
I have a table having certain rows now i want to show this rows in the columns. Please help me out...,
Thanks & Regards,
March 11, 2008 at 12:16 pm
Could you use SQL 2005? There is a pivot function there. Or you export your data to 2005, pivot, then, import back to your SQL 2000?
March 13, 2008 at 9:59 am
Dear,
i am using the MS SQL SERVER 2000, and you please help me in this version.
Regards,
March 13, 2008 at 10:05 am
You're talking about cross-tabulating... Look up "SQL 2000 Cross Tab" and you'll come up with a bunch of examples, including this one:
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/%5B/url%5D
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 13, 2008 at 10:06 am
For a better response, please read the following article. It provides excellent guidance on asking for help.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
There are plenty of people out here who would like to help, but you haven't provided enough info to really help at all.
😎
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply