May 24, 2013 at 2:18 pm
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!
May 24, 2013 at 7:17 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply