Yes. My code is doing exactly the same thing, but while also keeping the comparison on EH.EFFDT "sargable" for possible efficiency gains; big gains if the table is clustered on that date.
Yes. My code is doing exactly the same thing, but while also keeping the comparison on EH.EFFDT "sargable" for possible efficiency gains; big gains if the table is clustered on that date.