nicklibee (6/20/2013)
I just need the op displayed above....its just the count and the amount too be displayed.
thanks
nick
Well I don't understand the rules because it is very vague. I also don't understand how to join the tables. I guess you just want me to figure it out and do the work for you? You have to remember that I can't see you screen, I don't know your project or your data structures. The only information I have is what you have posted and what you have posted is not very clear. You came looking for an answer and I am trying to help you find that answer. The problem is that you have only posted part of the question. I can't help you if you don't provide the details.
_______________________________________________________________
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/