Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Royal Oak, Michigan, USA
    Thanked 0 Times in 0 Posts

    Access to SQL (2000)

    I have a simple crosstab report that works great in Access. Our management staff likes it so much they want to convert it as part of a web app rollout so I'm working with the web team. This simple crosstab report is causing much angst. They are developing it in ColdFusion which can use ColdFusion scripting or can use SQL. I thought this would be a breeze but they insist crosstab queries aren't supported in SQL Server 2000. I know this is a little off base but it doesn't seem to make sense that SQL Server (a Microsoft product) wouldn't support a crosstab query used in Access.

    Any thoughts on this one?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts

    Re: Access to SQL (2000)

    Strictly speaking, they are correct in that crosstab queries are not supported in SQL Server 2000. HOWEVER, if you do a search on cross-tab in SQL Server 2000 Books online, there are several topics that show up. One is called "Cross-Tab Reports" and the other is called "Transact-SQL Tips" and they suggest using either the CASE function or the CUBE or ROLLUP options of the SELECT statement. Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts