A quick comment on the "4 tinyints" idea. It does depend on your situation, but having it predivided into octets can actually make subnet handling more difficult, or at least...

And now is when I realize that I posted this topic in the wrong part of the forum. Sorry everyone. :blush:

Ah. Okay.

For some reason I was reading, "the nonscalar types, cursor and table, cannot be specified as a parameter data type in either Transact-SQL or CLR functions," to include user-defined...

I will say, one Cursor I haven't quite figured out how to eliminate, is when a vendor requires that something be done via a Stored Proc, and you want to...