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
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: Friday, June 19, 2015 7:47 AM
Points: 2, Visits: 66
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



Group: General Forum Members
Last Login: 2 days ago @ 10:58 PM
Points: 7,288, Visits: 13,140
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