This is not the correct solution as it won't check the combination of my type and will only check for the Code. For every index in Table 2 , I...

Thanks Chris, Just one thing, I havent mentioned but I thought I could query it myself. Below are the points :

1. I have 2 input parameters i.e., FromDate and...

This is the solution. Thanks for the efforts once again.

SELECT siteType,Code, avg([count]) [count],

avg(FailFlagCount) FailFlagCount, avg(Freq) Freq,

avg (CC) CC, avg(BPO) BPO, avg(Forecast) Forecast

FROM

(

select left...

Hi Sean, Well, I think I missed out only the "set dateformat dmy" in my insert statement. I have checked the same and it works fine for me.

There is nothing...

Thank you for the suggestion. Updated it accordingly.