RE: SQL Cross-Tab / TRANSFORM

2001-03-20 Thread Daye, Marianne
ormation Delivery Systems (IDS) http://ids.rti.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:39 AM To: CF-Talk Subject: RE: SQL Cross-Tab / TRANSFORM > We're using SQL 7 for all the database work, but we want to > comb

RE: SQL Cross-Tab / TRANSFORM

2001-03-20 Thread Dave Watts
> We're using SQL 7 for all the database work, but we want to > combine some tables (doing mods on a 3rd party program). We > thought to use Transform/Pivot. That avoids running hundered > of queries on a page (or even an additional 50) because of a > funny table structure. > > We approched t

RE: SQL Cross-Tab / TRANSFORM

2001-03-20 Thread cassady
Well ;-) We're using SQL 7 for all the database work, but we want to combine some tables (doing mods on a 3rd party program). We thought to use Transform/Pivot. That avoids running hundered of queries on a page (or even an additional 50) because of a funny table structure. We approched

RE: SQL Cross-Tab / TRANSFORM

2001-03-20 Thread Dave Watts
> Hey everyone - I have a question about Cold Fusion and trying > to read the Column name off of a Cross-Tab (MS SQL Server 7). > > I can generate the cross-tab without a problem, and if you > look at the query output in Access, it correctly identifies > the 11th and 12th Columns as Fax and Ph