Post reply

Crosstab query in SQL 2000

  • February 15, 2011 at 1:40 pm

    #142363

    In Microsoft Access, there is a crosstab query wizard to create a crosstab query. It make job more easier.

    How to create a cross tab query in SQL? Does SQL have a wizard?

  • February 15, 2011 at 2:00 pm

    #1287309

    Bad news first: No, there is no wizard.

    Now the good news: please have a look at the CrossTab article referenced in my signature. It'll show you how to do it using SQL Server.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply