Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored procedures to dynamically write classic ASP Expand / Collapse
Author
Message
Posted Friday, May 24, 2013 2:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 8:30 AM
Points: 1, Visits: 34
Hi, I'm hoping someone can give me one or two pointers here. I'm looking at a fairly old application which currently uses nested loops in classic ASP to load pages. Needless to say this is fairly slow so I am looking to rewrite this as SQL stored procs. The only was I can think to replicate the functionality is by using nested cursors which clearly is not ideal either, although we are not looking at vast volumes of data. Anyway, I was hoping somebody may have a more suitable and efficient solution. We are dealing with 3 levels of hierarchical data. Thanks!
Post #1456687
Posted Friday, May 24, 2013 7:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
Chances are good that a suitable set-based approach exists, however in order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results based on the sample data


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1456748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse