Small SQL Script / Stored Procedure wirttin
Budget: $10 – $30 USD
I need a stored procedure written without using a cursor.
2 parameters, @StartDate and @EndDate
Need to populate the following temp table.
DECALRE @TMP Table (
MonthYear VARCHAR(25))
For Example, if dates are 11/12/2020 and 3/4/2021 the table would be filled with
Nov ''20
Dec ''20
Jan ''21
Feb ''21
Mar ''21
That's it. I can do with a cursor but trying to avoid that.
2 parameters, @StartDate and @EndDate
Need to populate the following temp table.
DECALRE @TMP Table (
MonthYear VARCHAR(25))
For Example, if dates are 11/12/2020 and 3/4/2021 the table would be filled with
Nov ''20
Dec ''20
Jan ''21
Feb ''21
Mar ''21
That's it. I can do with a cursor but trying to avoid that.