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

Query performance Call Center data (19h)

Looking for on Premises tool to read data from SQL logs and populate data warehouse (1d)

Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (1d)

Working with multiple WHERE statements (1d)

Create a new field value that shows a difference in value from 2 fields (2d)

Hierarchy wise Sales Targets (3d)

Get the MaxDate in results (5d)

Switch Statement within a SSRS SQL Expression (6d)

- Advertisement -