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. 
UPDATE: All Web Dev content is being moved. This entry can be found here now. Be advised as this content will eventually get archived into oblivion!!!
