Thanks for your response Jeff. That solution worked well with that ID. What if the id column had like 5 numbers instead of 1 number. Like say inserting the following...

Hey Lynn, Thank you very much for your help and advice. It is very much appreciated. Happy Holidays btw !

Hey Lynn, love the article. I am assuming that replacing the delete statement with the update statement will suffice here in my case. I am also not concerned about the...

Thanks Lynn for your response to my question. To answer your question, Yes the previous updates will be excluded from the other updates. I will read your article now and...

For reporting purposes, we are still working towards a data warehouse so at the moment we rely on the oltp for reporting.

Thanks for your input, it has been duly noted !

Thank you for your help Jack, both replies helped a lot !!

Thanks for the introspective view guys, what about performance? How do you approach that if you were to select all records for 3 months and then 9 months and then...

Thanks for your input as well Benyos, it has been duly noted !!

Thanks for the response as always Lynn, are you suggesting initializing the @date parameters with an actual dummy date as opposed to intializing them with the variables to prevent parameter...

Worked like a charm. Thank you guys very much. Ill take this as my introduction to the usage of the row_number function. Thanks again. Lynn, about the extra table, I...

Hey Lynn,

Nice article on forum etiquette, here is some ddl information, hopefully it helps clarify my question.

ddl for productdetail table

CREATE TABLE #ProductDetail

...

The CTE was not a recognizable grouping option so I replaced it with a temp table and it gave me the result I was looking for. Thanks for all your...

I think you missed the average sale part, I need to get the avg of the sum of averages (if that makes any sense).

Like if averages are 10, 20, 30,...

Thanks a lot guys for the responses. Ill try it out and provide feedback. Thanks again !!