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.



>>I have a bunch of single letter codes for each date that I'm trying to string together, however the data may be missing dates for weekends and holidays. The result should look something like "ABBAC..CB.AA..BBAB....BACA"
>>
>>I can put the date, week, day of week, and letter code into an array with an SQL statement and walk the array - adding the weekend breaks seems easy, but I'm having difficulty with missing dates during the week. Can anyone help me with an algorithm or faster way to do this?