Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qutesanju
Posting Yak Master
193 Posts |
 Posted - 2009-07-13 : 11:10:23
|
| Hi all, 1 I have to run few graphs on monthly basis..... 2 those graphs will have queries associated... 3 I have to run those graphs on monthly basis using LASTRUNDATE field available in query.. (here I can increment date using date function....to get month wise date..) Is there anything available in sql server....... for above requirement |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-13 : 11:12:36
|
what do you need actually ? All the dates for a particular month ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-07-13 : 11:12:41
|
| You can set up a job to fire off a stored procedure or SSIS package on a monthly basis.Jim |
|
|
|
qutesanju
Posting Yak Master
193 Posts |
Posted - 2009-07-13 : 11:16:54
|
| is there any sample stored procedure for this?Instead of SSIS we are using datastage jobsI need to run this on current month basis/need to run on each month |
|
|
|
qutesanju
Posting Yak Master
193 Posts |
Posted - 2009-07-14 : 02:38:09
|
| Please check on this |
|
|
|
|
|
|
Automate graph on monthly basis