I would have created a job for this.

-----Original Message-----
From: Jeff Metcalf
[mailto:mssqldba-ezmlmshield-x33625425.[Email address protected]
Sent: Tuesday, January 30, 2007 7:40 PM
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

MS Sql Server LazyDBA home page