I’m using SQL Server 2000. I need to iterate through a view based on parameters and insert missing date ranges. My question is I need help getting started. This is what I have so far and it does not work. I'm hard coding values for simplicity.
Select * from qryStatusMissingDates where MonthNumber='6' and YearNumber='2007'
---Insert Missing Data