>Isn't this:
>
>

>CONVERT(char(8), Hit.AddDate, 112)
>

>
>the same as your expression
>
>

>CONVERT(CHAR(4),YEAR(Hit.AddDate))+REPLACE(STR(MONTH(Hit.AddDate),2),' ','0') + REPLACE(STR(DAY(Hit.AddDate),2),' ','0')
>

Yes, it generates the same result and at least four times faster. I am analyzing this now as to know if I can optimize more.