Thank you for your suggestion.this is my first post in SQL forum so was not knowing on the way it's done. I will make sure goung onwards to make the...

Thanks for the advise .I have reformat the code and here is a data example. what i want is the final output from these two tables Usage and Pair report....

Thanks lowell but i dont need to insert data into the table ,its just getting the result by using the below two tables. i would be  extremely thankful if you...

• This reply was modified 5 years ago by  Nikitamehta2101.
• This reply was modified 5 years ago by  Nikitamehta2101.