If you want to use this query going forward you should join on sys.dm_exec_sessions instead of sys.sysprocesses. This is a backwards compatibility view and is scheduled for deprecation. I...
I found the exact opposite on my dev enviornment. The CTE procs out performed the loop procedures. I used the scripts and ran through all the test scenarios and found...