>Hi,
>Thank you. May I know how to compare date only portion in SQL?
>I know we can use CONVERT() but would it be optimized since index cant contain function (could it?). ?
>
>Thank you
In my opinion it's better to create @dStart and @dEnd and compare date this way, but perhaps datediff function would already be optimizable. Can you run two simple tests to verify it?
If it's not broken, fix it until it is.
My Blog