Re: cross tab query from Access
From: Jack D. Ripper (steve.nospam._at_rac4sql.net)
Date: 07/29/04
- Next message: Peter the Spate: "Require Tunning Tips"
- Previous message: IT Dep: "Importing textfile into a cell"
- In reply to: Aleks: "cross tab query from Access"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Jul 2004 11:21:55 -0400
I'm shocked,shocked nobody pointed you to
the RAC utility for Sql Server:)
RAC is similar in concept to Access crosstab
but is much more powerful with many more
features/options.It removes all those silly
restrictions in Access, ie. just 1 Transform expr., etc.
Here is a simple formulation of your crosstab in RAC
on sql server: (note you can do this without 2 queries)
Exec RAC
@transform='Max(Userid) AS MaxOfMailStr',
@rows=[ID]',
@pvtcol='UserID',
@from='Atts INNER JOIN Cases ON Atts.CaseId=Cases.Id
INNER JOIN Users ON Atts.UserId=Users.UserId'
RAC is system of server stored procedures and functions.
It comes with a gui or it can be executed as a batch
in any client like query Analyzer.Of course you can use
RAC in your own stored procedures with parameters.
RAC v2.2 and QALite @
www.rac4sql.net
- Next message: Peter the Spate: "Require Tunning Tips"
- Previous message: IT Dep: "Importing textfile into a cell"
- In reply to: Aleks: "cross tab query from Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
