Hi,

Maybe you can try this if you want to avoid creating any temp table or using any cursor -->

SET ROWCOUNT 1

SELECT 'Start Removing Duplicate Record...' -- Don't remove, seed...

hi osoto,

By looking at your code, what not you try the following :

INSERT #DataResume

EXEC master..xp_srvpt_lastdlymult @params

instead of assign to @Cmd variable and execute it separately. I guess this...