Team - Good Morning. I'm kind of confused with the asp, sql loop.
Classic ASP, MS SQL 2008
What I have currently:
Have a form in classic asp which captures report details & its frequency (recurrence)
ReportName : ABC
Like daily, users will have options to choose weekly / monthly too & the pattern will change accordingly.
I also have a fiscal calendar table which has actualdate, fiscalweek etc.,
Using this query for "daily" Example:
Select cast(convert(varchar(10), ActualDate ,102) as datetime) AS ActualDate From tblFiscalYearNew Where
ActualDate Between '03/29/2013' AND '03/29/2014' AND FiscalDayDescription NOT IN ('Saturday','Sunday') Order BY ActualDate ASC
I am able to get the report instances(dates)
However I am stuck at this step.
Now, I need to use a query / loop to use the rest of the details + each date in a table.
Can someone guide me with a loop query which can save the output to another table pls