in the stored procedure I grabbed each record and checked if the count was > or < the max min values if it did I used sp_send_dbmail to send the...

Not sure what you mean. What part are you talking about.

thanks

Thank you for the responses. Decided to use a Stored Procedure to do what I wanted and then just scheduled the store procedure to run.

Thanks

Hi

Thank you again for all the responses. Been very helpfull.

Here is the code you asked for:

CREATE PROCEDURE dbo.usp_GetMonthlyFare

AS

DECLARE @Month ...

Thanks for the reply.

You have the Insert in front of the select. Is that on purpose? I guess what I am asking is, if you put an Insert statement in...

Not realy sure I get this article.:crying: First you show us a cursor example which in my opion is beyond simple. Are there really programmers out there that use cursor...

I am not using sql 2005. But I did download the version that comes with VS2005. I don't know what BIDS is????

Thanks

Ye I tried the sa account and got the same error.