Re: Need help
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 09/24/04
- Next message: Mark Wilden: "Re: Rounding Best Practice"
- Previous message: Myles Duffy: "SQL Cursor Syntax"
- In reply to: mjuricek: "Need help"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 25 Sep 2004 00:53:42 +0200
On 23 Sep 2004 13:36:45 -0700, mjuricek wrote:
>I'm trying to convert this script to single update command, but cannot
>figure it out.
>Script runs 36 seconds against my db I need to speed it up
Hi Mjuricek,
I looked into it a few times over the last days, but I simply don't have
enough information to know what the script does. And a suggestion based on
guesswork won't help you anything.
Please post the following:
1. Table structure of all tables that are relevant for the problem, posted
as CREATE TABLE statements. Include all constraints but exclude irrelevant
columns. See http://www.aspfaq.com/etiquette.asp?id=5006 as well.
2. Sample data that illustrates your problem. Post the data in the form of
INSERT statements. Test them before posting: create an empty database, run
the CREATE TABLE statements mentioned above, then the INSERT statements.
Correct errors, then post. See http://vyaskn.tripod.com/code.htm#inserts
as well.
3. Expected output, based on the sample data you gave.
4. A short and concise description of the business problem you're trying
to solve.
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Mark Wilden: "Re: Rounding Best Practice"
- Previous message: Myles Duffy: "SQL Cursor Syntax"
- In reply to: mjuricek: "Need help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
