>Hi, people
>
>I need to get sum of sales from a set of dates. Something like
>
>select sum(totalsales) from tbltable where caddate>=@somedate, but from a lot of dates.
>
>I could do that with a cursor but It takes a lot of time. Is there a way to do that in a set-based way
>
>
>TIA
Do you mean you want to pass many date ranges? What is the problem exactly?
If it's not broken, fix it until it is.
My Blog