Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 PIVOT and TRANSFORM

Author  Topic 

Fatalsniper
Starting Member

45 Posts

Posted - 2005-12-06 : 14:56:06
Hey Guys!!!

Is there such of thing as PIVOT and TRANSFORM function in SQL Server is there is in Access?

Thanks in advance...

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-06 : 19:48:21
looks like same as [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58700[/url]

-----------------
[KH]
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-12-06 : 22:47:46
SQL Server 2005 introduced the PIVOT operator. If you're still using an earlier version, there's also:

http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-07 : 01:24:40
>>SQL Server 2005 introduced the PIVOT operator.

Really good news

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -