So, have you tried setting MAXDOP to 1 on the query in your stored procedure? Did it help?

You should still explicitly name the columns in the SELECT clause. Not that it may cause problems, it is just that is, for many of us, a bast practice.

I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.

Is the Q: drive a mapped drive or a local drive on the server? If a mapped drive to a network share, you may want to change the path...

Sorry, you can't insert data into two separate tables with one insert statement. You'll need to do it in two steps.

Please tell me you aren't using the * in the SELECT clause in your production code. You really should explicitly declare the columns you are returning in a select...

Please take the sample data you provided, and create the expected output that should be generated by the query. Please don't just describe the output, show use what it...

Jan Van der Eecken (8/4/2009)

---

Thinking of Kassondra as well, Lynn, and wishing her good luck. But as you should know, she's being taken care of by pro's who will not...

Having found out you had double posted this request for help. I redirected everyone to this thread. Unfortunately, I failed to notice that one thread was in a SQL...

Curious why you have double posted this request for help? You now have two threads going with different people answering the same question and those in one thread not...

Bob (and every one else), I appreciate it. You may want to include me, her mom, and sisters as well. I have a feeling we may not hear...

Looks like you are wanting to calculate the volume discount for each customer in real-time as orders are processed, is this correct?

Could you provide us with DDL for your tables,...

Does the COGS calculation need to be run in realtime or as part of the end of day processing? Depending on the volume of data that needs to be...

is another way to it without the cross join (on 1=1 in the ON clause of the inner join):

SELECT

ii.item_name,

ii.date_issued,

...

This was possible in SQL Server 2000 using SQLMail, but I have not found any way at this time to do so with DatabaseMail.

I think it may have been considered...