I use rCTE for account control and access on our websites. Best way to go, haven't found one that's faster, including hierarchyid. I'm thinking hierarchyid loses on my...

Couldn't you just use the following?

SELECT DATEDIFF(wk,@StartDate,@EndDate)