• They are two totally different stored procedures. You shouldn't be looking at their execution times collectively. Proc 0 will always take less time than Proc 1 because the only thing it does is say "Hey, SQL Server, Run this other guy."

    Which is a very weird way of doing things. Why aren't you just calling Proc 1 straight instead?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.