Yeah,
I am already using an SP for the query, but it's huge and has a bunch of
case statments, and CAST() and CONVART() in it. I am trying to do as much
on the SQL Sevrer as possible with this query so I can make it run pretty
quick. I will look at pivot tables, thanks.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
> -----Original Message-----
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 29, 2002 10:19 AM
> To: CF-Talk
> Subject: Pivot table WAS: SQL Question
>
>
> look into pivot tables in the Books Online. that'll do it.
>
> you might also want to use an SP, they'll handle it faster.
> return the data set of the pivot table to CF, and you're in.
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -----Original Message-----
> From: Timothy Heald [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 29, 2002 9:49 AM
> To: CF-Talk
> Subject: SQL Question
>
>
> Hey folks,
> I have a table like this:
>
> id foreign id value
> 1 1 1
> 2 1 2
> 3 1 3
> 4 2 1
> 5 2 2
> 6 2 3
>
> Regular old normalized table right? Well I need to get it
> into columns
> like this:
>
> foreignID value1 value2 value3
> 1 1 2 3
> 2 1 2 3
>
> Now I know it is possible, but difficult. I would do it
> with CF but no
> matter how high I set the time out in my administrator, and my
> web server it
> times out, or says page cannot be displayed. It is pulling huge
> amounts of
> data, then outputting it it an Excel spread sheet. We tried to
> do it with a
> DTS package and the use SQL Mail to send it, but couldn't get that to work
> reliably.
>
> TIA.
>
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
