michielbijnen (7/5/2014)
Unfortunately I am not able to attach the 2 images properly in my reply ...I used the image shortcut with an absolute URL to my local system using syntax "file:///C|/dir1/dir2/filename.png".
No spaces in the filename ...
How can I attach a file from my local computer?
When posting, scroll down. In the bottom right corner is an Edit Attachments button.
Excellent job posting ddl and sample data. Hopefully the attachments will help but also a description of how you want these calculations would be a big help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/