I can confirm that (MAX) (any form) variables are passed byVal up to version 2K8 R2. byRef is reserved only for the table variable parameter, and that is a read only item once it's generated. XML is also byVal. The easiest way to confirm is to nest a procedure and alter it in the subprocedure. Then return it from both the nested and the calling procedure.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA