dbTalk Databases Forums  

Easier way of building pivot tables in MS SQL Server

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Easier way of building pivot tables in MS SQL Server in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
wujtehacjusz
 
Posts: n/a

Default Easier way of building pivot tables in MS SQL Server - 07-10-2007 , 04:19 AM






Dear All

I am very new to MS SQL Server and I am wondering is there some tool
which would allow me to build pivot tables in SQL more easily. At the
moment writing a query can be quite challenging and difficult.

Is there any software which allows you to do it more intuitively and
gives you some visual feedback about query you are building?

I would be very grateful for any help with this.

wujtehacjusz


Reply With Quote
  #2  
Old   
Jason Lepack
 
Posts: n/a

Default Re: Easier way of building pivot tables in MS SQL Server - 07-10-2007 , 07:25 AM






What version of SQL Server?

SQL Server 2005 has the PIVOT command.

On Jul 10, 5:19 am, wujtehacjusz <wujtehacj... (AT) gmail (DOT) com> wrote:
Quote:
Dear All

I am very new to MS SQL Server and I am wondering is there some tool
which would allow me to build pivot tables in SQL more easily. At the
moment writing a query can be quite challenging and difficult.

Is there any software which allows you to do it more intuitively and
gives you some visual feedback about query you are building?

I would be very grateful for any help with this.

wujtehacjusz



Reply With Quote
  #3  
Old   
Dan Guzman
 
Posts: n/a

Default Re: Easier way of building pivot tables in MS SQL Server - 07-10-2007 , 07:29 AM



For SQL 2000, check out http://www.rac4sql.net/

--
Hope this helps.

Dan Guzman
SQL Server MVP

"wujtehacjusz" <wujtehacjusz (AT) gmail (DOT) com> wrote

Quote:
Dear All

I am very new to MS SQL Server and I am wondering is there some tool
which would allow me to build pivot tables in SQL more easily. At the
moment writing a query can be quite challenging and difficult.

Is there any software which allows you to do it more intuitively and
gives you some visual feedback about query you are building?

I would be very grateful for any help with this.

wujtehacjusz



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.