SQL Server crosstab utilityBy 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."
|
- Advertisement - |