>>Guess I didn't explain well or ask the question right. Getting the dates to/from SQL was the easy part. The hard part is converting it all to a string that properly adds periods for the missing(holiday and weekend) dates.
>>
>>Your solution would give me a cursor that includes missing dates... halfway there. Walking that cursor could work, but I have to solve another issue with skipping/ignoring completely empty weeks.
>>
>If you have a cursor with all dates and some indicator, that this date is missing, then what seems to be a problem of scanning this cursor and using if/endif logic for . ?

Mostly the IF/ENDIF logic. ;) Having to account for missing days at the beginning, middle and end of the week, plus skipping to the next week when necessary. Long day and it was getting muddled in my head. New day, new ideas, something should work.