loop the job
Posted: Tue Aug 05, 2008 6:53 am
In select statement i have to pass the parameters dynamically and its need to run through loop.
dynamic sql
where row_eff_date between #start_date# and #end_date#
first time it needs to run from the start_date = 20050101 and end_date = 20050331
second time : 20050401 to 20050630
like this i have to run quaterly to till date.
can any body please help me
Thanks
dynamic sql
where row_eff_date between #start_date# and #end_date#
first time it needs to run from the start_date = 20050101 and end_date = 20050331
second time : 20050401 to 20050630
like this i have to run quaterly to till date.
can any body please help me
Thanks