I like the script, it will be useful.

I have added the following to your code:

DECLARE

@sql VARCHAR(2048)

,@sort INT

DECLARE tmp CURSOR FOR

then your code goes here.

OPEN tmp

FETCH NEXT FROM tmp INTO @sql, @sort

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT @sql

FETCH NEXT FROM tmp INTO @sql, @sort

END

CLOSE tmp

DEALLOCATE tmp

The result is now text that can be copied into another query window and run or saved to a file.

Thanks for sharing your code.

Bill