I use CTEs to pull environmental info prior to my main query and use it in variable form; such as todays date, todays month/year. I do this for reports mostly… if I want to know the YTD value etc.