Using cursor with Common Table Expressions

CteWithinCursor.sql

-- declare a cursor above the CTE definitions
DECLARE myCursor CURSOR FAST_FORWARD_FOR

-- declare CTEs
WITH CTE1 AS
(
   -- CTE1 definitiion
)
,CTE2 AS
(
   -- CTE2 definitiion
)

-- select query as normal
SELECT ... FROM CTE2

-- now open and use the cursor and don't forget to close 
-- and deallocate it in the end