Not as simple as that, sorry
Two distinct jobs which one with different steps, that is why I am having difficulties: crying:

The SP delete all records from the table "Imart.ChurnRate" and then inserts information from two other different tables with these column names:

BASE.SUBS_WEEK_AND_YEAR, DAY_ID, DATE, CHURN.BB_PACKAGE ,CHURN.DTH_CUSTOMER_TYPE, CURRWK, LASTWK,...

Hi, Many thanks for your reply. What I'm trying to do is running a script/code which I put in a ‘Stored Procedure’ after the other two jobs have completed successfully
...

Thanks,

I won't have time to check it today, but I will check it tomorrow, and will let you know.

Many Thanks,

Hi,

I been using 'Simple Date in month to date',

also used

AND(Simple Date >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1), Simple Date < DATEADD(DAY, 1, TODAY()))

but what I really would like is that...

Thank You for the help, seems to work

Apologies, if I not explain correctly the issue, which is:

I am using Visual Studio 2005, and I can buid the query, I set up the parameters Start Date and End...

Thanks, I will be posting the query there.