HOME Welcome to RAC
The Relational Application Companion
written exclusively for SQLServer
 
News

Products
  Rac for SQL2K
   Rac Gui Screen Shots
   Rac Documentation
   F.A.Q.
  Rac for SQL7
   Quick Tour
  QALite.Net (Free)
  ObjectScriptr (Free)

Online Purchase
  Rac for SQL2K
  Rac for SQL7
  Additional CALs

Download

Contact Us

Links

Misc
  Xp_Execresultset
  BOL-TO-MSDN

Rac v2.x for SQLServer 2000

Version 2.x features include:

  • Crosstabs with multiple summary values in various formats
  • Row and grand totals with control over placement
  • Field labeling
  • Value substitution for empty and null cells
  • Sorting rows,columns and summary values
  • Forcing column values
  • Adding fields and values
  • Partitioning rows and columns
  • Row and column percentages
  • Running sums over rows for specific columns
  • Applying server functions to summarize rows
  • Transpose columns to rows
  • Create delimited transform (aggregate) strings for rows over columns
  • Split delimited strings into columns
  • Macro substitution
  • Save result to:
      a database table
      a text file
      a XML file
      a HTML file
  • Send result to email recipient(s)
  • Save SQL script to file for later use

    You will find RAC useful for solving many types of problems where rows have to be pivoted to columns.And much more.

Clicking on a link below for a quick online tour of RAC for SQLServer 2K.

Rac Gui Screen Shots

Contents of Rac Documentation

F.A.Q.


Purchase RAC online at www.Emetrix.com

 
© 2002 Rac4sql. All rights reserved.