Can you use an autogenerate and a from statement in the same load? I have 3 columns, Dept Code, 2012 bed count and 2013 bed count.
What I want to do is have dept code and then a date for every day in the year so 1/1/2013 --> 12/31/2013 with the value from the corresponding bed count column for every date of the year. Attached is an example of what I have currently. Any help would be appreciated.