Try this:

If Datepart(d, getdate())= 1 insert into contributions (custnmbr,
periodid,year1) select custnmbr, month(getdate()),year(getdate())

EXEC myproc1
EXEC myproc2


-----Original Message-----
From: Jeff Metcalf
[mailto:mssqldba-ezmlmshield-x33625425.[Email address protected]
Sent: 30 January 2007 14:10
To: LazyDBA Discussion
Subject: Question about logic and stored procs


I have a large proc that loads a warehouse db every night. Right now on
the first of the month I manually run a proc to load the master tables
and I want to automate this also...it

If day(getdate())='1'
then
insert into contributions (custnmbr, periodid,year1)
select custnmbr, month(getdate()),year(getdate())
then run the rest of the procs
else if day(getdate())<>'1'
then just run the rest of the procs

Help, as always, is much appreciated.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page