J.T.

Wanted to get your opinion on using this method you proposed versus using Dynamic SQL and say sp_executesql or EXECUTE?

1. does the optimizer handle them diffrently. 

    a. Are they treated as two seperate query plans for the same query or one.

    b. Can XP_EXECRESULTSET take advantage of the caching of multiple calls from various users that sp_executesql can

    c. do you execute a XP_EXECRESULTSET  query with the same SPID as the current connection or is a new one made?

This is all I can think of off the top of my head anyone have other comparisions to ask let them rip.