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
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.