GeckoWare SQL Crosstab Builder for Microsoft SQL Server
Current Version: 3.0.0.0 (32bit and 64bit)

NEW Online demo . Click here - Crosstab Builder vs Microsoft PIVOT (11:30mins)

Quick list of Features

• Supports SQl Server 2000 and 2005 (32bit adn 64bit)
   
• Powerful Pivot/Crosstab generation for SQL 2000 & 2005
   
• Output results or output to table
   
• max 10,000 output columns in the resultset
   
• Incredibly quick, 1000's of rows and columns in seconds
   
• Wizard query builder for ease of use
   
• Easy Installation
   
• Support up to 10 columns to generate crossab results on. This means you can select to crosstab say the Sales Region colum and Sales City columns all in one simple call. You can't do that with any other tool!
   
• Supports unlimited amount of value columns. Using this feature you can product a Total Sales per region plus Average sales per region plus Max sales per region all in one call. Again no other tool allows this flexability!
   

GeckoWare Crosstab Builder for Microsoft SQL Server is an extended stored procedure will generate crosstab results from standard SQL statements. You now do not have to run OLAP services to generate what Microsoft Access has been able to do for years.

GeckoWare Crosstab Builder for Microsoft SQL Server is simple to use. See the On line instructions for an example of what xp_ags_crosstab can do. Easy to use with our new Wizard program which helps you generate perfect syntax. xp_ags_crosstab is extremely fast generating 1000's of columns of data in seconds.

• No more temp tables
• Faster coding returning faster results
• New output to table, allows you to use the results in further procedures
• Compatible with Version 1
• New Wizard program to help you develop xp_ags_crosstab syntax
• max 10,000 output columns in the resultset
• Easy installation and set-up will get you up and running in a matter of minutes

  Remove the pain of developing complex crosstab queries, GeckoWare Crosstab Builder for Microsoft SQL Server does it all for you!

If you are converting from Microsoft Access to SQl Server GeckoWare Crosstab Builder for Microsoft SQL Server is the best and simplest solution to replace Access crosstab queries. In fact that is the reason it was created. Microsoft even acknowledges its importants in conversion. They mention it in their document How to Migrate to SQL Server!