I got a solution for creating a 12 month annual report that would count pgms for each mon.
so, jan -dec the pgm would have a value. If there was no record for the pgm in a month, the month got defaulted to '"0". Perfect solution. I am attaching original sql code, is there any way to turn this into a "rolling" 12 month? I believe the current usage of spt_values table will not work for the months.
I have been making attempts to recode this to generate rolling. I have new sql that appeared to work, but the records ended up in wrong months (attaching after original code).
I appreciate any help.