I already answered this question under your other post.

He is right when he tells that it will cause degredation. However to cause major problems you would have to run these procs a few 1000 times/hours (if the result...

I just played with it... have a go with this script and post the final result to us :

if object_id ('Replaces') > 0

begin

drop table Replaces

end

GO

if object_id ('Dummys') > 0

begin

drop...

Always depends on how you "loop" but I think you can figure out a fast way of doing that.

Maybe I can help you with concatenating on the client side...

read this for an exemple of a quick concatenation script :

http://local.15seconds.com/howto/pg000929.htm

CASE WHEN Max(SalePrice) > 0 THEN Max(SalePrice) ELSE CASE WHEN Max(UnitPrice) > 0 Then Max(UnitPrice) Else 1 END END

if you need more than 8000 characters I would suggest doing the work on the client because it's gonna be easier there than working with a text variable on the...

Dim db As ADODB.Connection

'add this

set db = new adodb.connection

db.Open "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=Agency ControlSQL;Data Source=servername", "userid" "password"

WHERE AND HAVING are very similar, but your conditions differ from one another because of the max operation.

Try removing the (MAX(Orders.OrderDate) to only Orders.OrderDate > DATEADD(d, - 90, GETDATE())

as I stated earlier :

HAVING (MAX(Orders.OrderDate) > DATEADD(d, - 90, GETDATE()))

IS VERY DIFFERENT than

WHERE (Orders.OrderDate > DATEADD(d, - 90, GETDATE()))

add MAX(Orders.OrderDate) and COUNT(*) from the first select query to...

it's still not enough info to help you (no table definition)..

Try running the first query without the sum/group by and find out which lines are missing for a product compared...

Why is it painfull to have a task run more than once per day?

can you post the DDL and some of the data from the table along with the results from each of the queries? I can't help you further without that.

I haven't checked the whole thing but this jumped right to my face :

GROUP BY Products.Manufacturer + ' ' + Products.ProductName

HAVING (MAX(Orders.OrderDate) > DATEADD(d, - 90, GETDATE()))

WHERE (Orders.OrderDate >...

Maybe not what you want to hear, but don't use a cursor.

Can you post the SP so that we can provide alternative solution to the cursor and check for small...