Easier way of building pivot tables in MS SQL Server

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

Re: Easier way of building pivot tables in MS SQL Server

What version of SQL Server?

SQL Server 2005 has the PIVOT command.

On Jul 10, 5:19 am, wujtehacjusz wrote:
> 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

Re: Easier way of building pivot tables in MS SQL Server

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

--
Hope this helps.

Dan Guzman
SQL Server MVP

"wujtehacjusz" wrote in message
news:1184059198.208520.109590@q75g2000hsh.googlegroups.com.. .
> 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
>