Something important to remember though about COALESCE is that it will return out the data type of the expression with the highest data type precedence. This isn't...
I've got to agree with Jereme. I'm currently working on a legacy system which is FULL of OUTPUT Parameters (which sadly more often than not contain nothing of use on...