• I wish!

    You're just moving the testing from one place to another arent you? It's the same code, only difference is how you get there. Or you could even just pass a param to the "main" proc and have it do this:

    if param=1 then

    exec proca

    if param=2 then

    exec procb

    Andy

    http://www.sqlservercentral.com/columnists/awarren/