I have data file where i want to load the data into Sql Server 2005 and to write a procedure with date parameter so that I should be able to get the report like below:
Report output should be like as below:
[ Week Agerage Call ],
[Week Average Duration]
And similarly I should be doing this for month and year where all togather I can get the report of weekly , monthly and yearly stats.
Attached is the data that I am having.