Re: Please help me with this query...thanks

From: Otis B. Driftwood (nospam_at_aol.com)
Date: 02/22/04 

Date: Sun, 22 Feb 2004 16:39:56 -0500

"Dandy WEYN" wrote:
> You need to pivot the table
> http://www.dandyman.net/sql/samplesByTopic.aspx?topicid=2&id=6

If you have pivoting with sql server on your mind
perhaps you would like to check out the RAC utility for S2k.
Be aware that RAC cuts to the chase:

No more Cursors,
No more Case,
No more sql Code to put in your face:).

RAC and QALite @
www.rac4sql.net

Relevant Pages

  • Re: excluding fields in SELECT statement
    ... I guess this is what Dan had in mind. ... There is a new product PromptSQL which claims to provide intellisense to ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Help with Query
    ... What the @!$% specs for this?? ... > mind and guess that you want to see only those rows whose col_1 groups ... this is not what minimal nettiquette is about. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: How do I Convert a Date/Time Field to Just a Date Field?
    ... clarify, I don't mind using a time value in my "converted" date/time, so ... as no such datatype exists in SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Data Adapter UpdateCommand
    ... Never mind, I found what the error is....it was an authentication ... I wasn't using the global connection to my SQL server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Stray poll: DBs for Delphi non-tech
    ... Bearing in mind that the database choices are not mine to make, ... SQL Server and Access for the last two big projects on PCs. ...
    (borland.public.delphi.non-technical)