syed_3177 (2/10/2016)
....Further details provided.Thanks
Further details will need to be provided! Minimum requirements:
CREATE TABLE scripts for all tables.
INSERT scripts to populate those tables with a few rows of data.
A script to generate the expected output from that data.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden