This might be brought up earlier but same task can be accomplished by using simple VIEW without using CTE. In any case using row_num() in a separate query and recursive...

What we're doing is simple as long as you script your database changes from DEV to PROD. Here how it goes.

1) We backup PROD database every day (week or month....

Fixed a bug;

Your generation sproc was ignoring the schema when using "EXEC sp_helptext @ProcedureName". Added below to fix the issue.

...