>Just because it is a server CPU you don't have to mistreat it ;-)
>Calculating once on the client is probably always more efficient than calculating each row server side, even if the same result set is generated.
>
>
The Years is a column in that same table, so you can not calculate in advance. I was trying to figure out a good solution here, but I don't think there is one besides using dateadd function. Of course, instead of sending a string you need to send date as a parameter.
If it's not broken, fix it until it is.
My Blog