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: 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



Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1456748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse