Originally Posted by BeerOclock

corncrowe, leaving a parameter undefined or null causes the query to return nothing. In the example you provided, if @id was null, then no rows would be returned. I could get rid of the where clause entirely however...

Thanks for your help all. If no one else has any tricks for me, then I guess I have to bite the bullet and dissect this procedure line by line...