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

DROP Table #TempTable (2h)

Unpivot (6h)

What variable type could I use in a trigger to read information from a text field (8h)

Missing Range from SQl Table - TSQL (1d)

Insert trigger to run an ASPX script passing record columns as parameters (1d)

Find the closest date with associated column (2d)

SQL Query Help with roll up (2d)

Need help creating trigger to capture single and multiple updates (2d)

- Advertisement -