Guest_imported
New member
- Jan 1, 1970
- 0
I am working on a project that requires that we display data in a cross tab query. I haven't been able to find a SQL statment or format that works properly.
I have been able to do the query with nested "do while" statments and incrementing dates, but this method takes a quite a bit of time. It is essentially running various SQL statments over 3000 times to create the page. These pages take 1-2 minutes to load and I'm trying to speed this up.
Is there a faster way do do a crosstab query with ASP. Utilizing Access this is a very easy task, however, I need to display this data with ASP.
I've tried working with CASE statments, however have had no luck in actually reporducing the results that I receive with Access.
If anyone has a method, I'd be happy to have them look at the pages that I've created to take a closer look.
I have been able to do the query with nested "do while" statments and incrementing dates, but this method takes a quite a bit of time. It is essentially running various SQL statments over 3000 times to create the page. These pages take 1-2 minutes to load and I'm trying to speed this up.
Is there a faster way do do a crosstab query with ASP. Utilizing Access this is a very easy task, however, I need to display this data with ASP.
I've tried working with CASE statments, however have had no luck in actually reporducing the results that I receive with Access.
If anyone has a method, I'd be happy to have them look at the pages that I've created to take a closer look.