Cross-Tab Query

[EdMacDonald]

I would like to perform the equivalent of an MS Access cross tab query in SQL server 7 where the values of a chosen field become fields of the the result set.&nbsp;&nbsp;And I'd rather not use MS Jet as an intermediary.<br><br>I'm thinking there ought to be a stored proc floating around for this one.&nbsp;&nbsp;Anyone have something like this?<br><br>Thanks,<br><br>Ed<br><br>

 

[foxdev]

Well, Ed, no one's jumping in with a better solution, so I'll give the standard Microsoft answer:&nbsp;&nbsp;Excel's Pivot Table. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[EdMacDonald]

It's for a web based enterprise application so Excel is not an option.<br><br>I could stick JET in the middle, by creating an Access DB with a linked table, but that's kind of hokey.<br><br>I'll probably do it the hard way by manipulating ADO recordsets in VB in the middle tier.<br><br>Ed

 

[RangerFan]

I don't have a whole lot of experience with SQL Server, however, we have done some cross-tab reports using a<br>combination of a SQL 7 stored procedure, Crystal Reports, and a VB front end menu selection to launch the report.<br>Use the stored procedure to extract the data fields that<br>you want and then build the cross-tab report in Crystal.<br><br>Also, take a look at SAMS Transact-SQL in 21 Days pages<br>428-434 for cross-tab stored procedures.

 

[EdMacDonald]

Thanks,<br><br>I've already written a VB cross-tab function for my data access module, but I'll try to get a look at the book too.<br><br>Ed

 

[emuti]

Answer: R(eplacement) for the A(ccess) C(rosstab) query

Go to:

http://www.angelfire.com/ny4/rac/

it is a collection of stored procedures to create cross-tab queries. I, myself, asm looking for a way too... However, I'm an amateur with sql server, so still trying to figure out how to use RAC. Let me know if you come upon anythign else. Thanks.