Help: Is there a better way?

Hi All,

I started this report pulling from a SQL Server 2000 db. I'm pulling to
recordsets, the second based off the results of the first. So really,
its an rs loop within an rs loop. It works alright but man its so slow,
I dont think it will be acceptable. I wanted to know if there is a more
efficient way to code this?

Here's my code...

Re: Is there a better way?

bill wrote:
> Hi All,
>
> I started this report pulling from a SQL Server 2000 db. I'm pulling
> to recordsets, the second based off the results of the first. So
> really, its an rs loop within an rs loop. It works alright but man
> its so slow, I dont think it will be acceptable. I wanted to know if
> there is a more efficient way to code this?
>
There is probably a way to constuct a query to avoid the inefficient rs
loops. Unfortunately, without any details about your table structure(s), or
what you wish the outcome to look like, it's impossible to make suggestions
without spending a lot of time trying to reverse-engineer it from your code
(something I am not ready to do). Please provide table-creation scripts
(DDL) and sample data per the suggestions mentioned in www.aspfaq.com/5006.
And make sure you show us what the output from that sample data needs to
look like (don't just describe it - show us)

In the meantime, you should read:
http://www.aspfaq.com/show.asp?id=2201

As well as this:
http://tinyurl.com/jyy0
which will show you how to avoid the threat of sql injection by using
parameters instead of dynamic sql

Also, nothing to do with your problem but you should read:
http://www.aspfaq.com/show.asp?id=2126

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Is there a better way?

Well I don't have access to the SQL server to generate the scripts
you're talking about, I'm just given the task of coding it. so thanks
for nothing I guess.

Re: Is there a better way?

"bill" wrote in message
news:1127403869.839800.164260@g44g2000cwa.googlegroups.com.. .
.... so thanks for nothing I guess.

Now that was uncalled for.
And you'll never get much help with that attitude.

Re: Is there a better way?

So tell my mommy... in the length of time the prick (judging by his
other posts) took to spew his bureaucracy he could have given an
answer. This wasn't a difficult question and you don't need test data
to judge whether someones coding is optimized for performance - gfys

Re: Is there a better way?

"bill" wrote in message
news:1127410688.710888.79970@z14g2000cwz.googlegroups.com...
> So tell my mommy...
Somebody should.

> in the length of time the prick (judging by his
> other posts) took to spew his bureaucracy he could have given an
> answer.
He did give you an answer.
Did you even read the links?

> This wasn't a difficult question and you don't need test data
> to judge whether someones coding is optimized for performance -
www.aspfaq.com/5006... again

>gfys
*PLONK*

Re: Is there a better way?

troll

Re: Is there a better way?

bill wrote:
> Well I don't have access to the SQL server to generate the scripts
> you're talking about, I'm just given the task of coding it. so thanks
> for nothing I guess.

Well that's kind of silly. Instead of figuring out a different way to
provide the information I requested (or asking us to suggest an alternative
method), you simply decide to flame me ...?

plonk
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Is there a better way?

well, boss was pretty cranky today and that obviously came through loud
and clear in my texts. Truth be known the table content is classified
so your answer wasn't an option for me. But I did manage to clean it up
and speed it up today using your links. Thanks.