Видеопродакшн

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

You can't use this from within a CTE. It has to be used in the main query. I wanted to limit the amount of rows returned (pagination) and then perform an expensive calculation to the 10 or so rows returned, rather than determine the rows, perform the expensive computation, and then skip/take what I needed. @Aaronaught's answer will work for those needing to restrict rows within a CTE