RAC is a native utility for MS SQL Server, designed exclusively for data manipulation.
RAC uses a common framework that can be manipulated to summarize data, perform
pivoting operations including crosstabulations, character operations including
string replacement, splitting, concatenation and processing hierarcharical data.
RAC offers many computational options as well as report writer features such
as those found in Access Reports and Sql*Plus. In addition to performing specific
tasks it can be used a general problem solving tool. RAC is designed to eliminate
complex sql but is also highly integrated with sql server to allow users to
extend its capabilities. Any RAC result can be saved as an SQL Server table
in a number of easy ways. RAC can be used in batches and stored procedures.
RAC for SQL Server 2000 comes with a GUI to allow novice users to generate
complex summaries, reports or any type of result of their choosing easily and