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

Checkmark for guaranteed SR = WR (96m)

How to connect to git in SQL Server 2016/2017 without using any third party tool (104m)

Sql restart (7h)

Excel column wise data save in rows (1d)

Date timzone conversion (1d)

Object cannot be cast from DBNULL to other types coming randomly in SSIS Package-Migrated from VS 2008 to 2015,SQL 2008R2 to SQL2016 on 1st run only (2d)

Error in sp procedure- Msg 50000, Level 16, State 1, Procedure spCheckDBInfo, Line 193 [Batch Start Line 0 (2d)

Two records into a single record? (2d)

- Advertisement -