• Ramesh,

    Yes you can use variables in CTEs.

    Ganesh