SQL: Sometimes you just have to check the param list

I don't know how many times I've run into errors caused by the fact that I wasn't paying attention to dependencies between SP's that call other SP's.

Got this one because I added a parameter and forgot to check for dependencies. The resulting shift of parameters (calling SPs would be one param short so it's like they were shifted up/left by one) caused this error because the parameter that was next was an XML param:

Operand type clash: int is incompatible with xml

Never know what you're gonna get. :)