I appreciate the insight on Top. I am about as "Old School" as they get, and a lot of times, revert to "tried and true" as default. I am going...

I've had similar experiences. I wound up deciding to make it a habit to not push the limit, and restrict myself to using varchar(7980), as that seems to be the...

I've run this scenario through several itterations on a test server, and come to the decision that since the computation doesn't happen till real time, it cannot pre-validate it. It's...

If the server was identical, that would worry me. I think I would want to know why it acted differently.

I do not see anything there that would be a problem. And since the precedence of * and / are equal, and it will perform them in the order given,...

Set rowcount 1

select @Temp_Hand = avg_qty

from distant.db.dbo.id01

where field1 = @curr_field and

field2 = @curr_field2 and

field3 = @curr_field3

If @Temp_Hand = NULL

Set @Temp_Hand = 0

Set rowcount 0

Return (@Temp_Hand)

Also, even in the case with...

I realize that this isn't the answer that you would be looking for, but your selecting a single field from a single record and using a cursor to do it....

I have seen issues similar to what you describe in a project before. It turned out to be conversion issues. You might check out the data types returned in the...

Are your DNS, WINS, or Active Directory, possibly hosted services. If not, and they are in house, so to speak, check for entries referenced in them for the same name...

That helps, then. In enterprise manager, your results are being generated from the sysindexes table, which is only correct if the modified row count column has a zero value. In...

Excellent Advice Steve, and I think that its an area that is all to often overlooked. It's what I've termed the PRIDE FACTOR. I make a point of mentioning it...

My first sugesstion would be Books Online. Comes with Sql Server, and I believe Microsoft's Tech Net or MSDN sections would be the next suggestion. Specifically, the Transact SQL reference...

Ahhh, now that makes more sense. And in that case, I finally see why you believe that multiple nulls SHOULD be allowed. And now I can't help but believe your...

Where does Sql-99 state that it should allow multiple nulls in a unique constraint? That contradicts the "NULL duplicates NULL" (but "NULL never equals NULL") statement.

Your example shows that the...

In that case, I would believe that there are different definitions for Unique between the systems. Unique by any definition I ever heard was defined as "Having No duplicates", or...