SQL Server crosstab utility

By Bill Graziano on 25 February 2001 | Tags: Tools


stevie submitted "RAC (replacement for Access crosstab) while similar to Access offers many more features and options including functionality found in Access reports, Excel, Crystal and Oracle sql*plus. RAC is a set of stored procedures running on sql server 7/2000 and is written entirely in t-sql. RAC contains a large array of parameters that allow crosstab/reports to be constructed containing many computational additions in a number of different configurations with report type formatting.RAC can accomodate any level of user. While RAC hides much of the complexity of sophisticated sql more advanced users can take advantage of RAC within t-sql batches and procedures and via ado. RAC can also solve various pivoting problems including forming concatenated delimited strings of columns over rows. RAC v1.50 exclusively for server 2000 is still under development but a beta is available for download.New features are being added as well as the development of a gui."

Link: SQL Server crosstab utility


Related Articles

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Free online SQL Formatter (5 April 2006)

Free tools for SQL Server (2 March 2006)

Software Review: SQLCompare (27 April 2004)

Compare SQL Server databases (2 May 2003)

Foam - FOR XML EXPLICIT Tool (9 August 2002)

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III (7 August 2002)

How to troubleshoot orphan users in SQL Server databases? (6 August 2002)

Other Recent Forum Posts

Cannot Show requested dialogue - Timeout Expired. The Timeout priod elapsed prior to completion of the operation or the server is not responding (4h)

Basic SQL query? (16h)

T-sql - we created Message from app1 and trying to disable from app2 (1d)

SQL select Top 10 records for unique combination of two columns (1d)

SSRS Report Sorting with Grouping Issue (2d)

ORA-01476: divisor is equal to zero (2d)

Create new columns based on min and max values of a record with multiple rows (2d)

Memory Required for Reporting Services 2022 (2d)

- Advertisement -