I was able to solve this using some simple code from this;

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e75d0137-d386-4491-9093-78590d2cddf0/division-by-0-error-when-using-reportitems

Thanks

Thanks for trying but, this did not work.

Thanks for the responses. I'm unsure what got into me..? I will use SSIS as I always do. Thanks

Thanks. This is what I was thinking and your response just confirmed.

Thanks Phil,

I was just responding with that. I was wondering if anyone had thoughts with regard to the best method using SSIS.

Thanks so much!! This was perfect and, perfectly logical.

Thank you so much. This did the trick

That is exactly what I am hoping to do.

Thank you for the quick response

Sean, thanks for the (as usual) fast and helpful response. I will need to think of some other creative ways to grab that data. Thanks again.

Thanks a lot Sean. This works perfect for the requirement.

Thank you. That worked perfect.

Yes, I do want all of those columns. I have decided that I'm going to try and handle for this in SSIS. I thought I was going crazy that I...

I love the idea of a date tally table. Great idea. I will create one and hopefully that will be a great place to start.

Thanks a lot!!!!

There will not be an exact (date match) in the exchange view. This is updated once per week.

What I was thinking about doing is adding a week and year number...

Thanks Phil,

I definitely have questions. It's late on Friday and my logic has gone out the window.

My questions are basically,

1.where do I put it within my data flow

Ex: My data...