Ben, I would suggest to you as well to run a simple test.

You cannot believe how much stuff you can find in Internet is absolute cr.p.

And you probably missed this:...

dmbaker,

I wish you read it as many times as you posted it.

an exact representation of the number

Representation is named exact, not the number.

I really don't know what they mean by...

Why don't you run a simple test and show results to your boss?

dmbaker,

in definition of datatype "DECIMAL (s, p)" what is "p"?

What is the range of possible values of "p"?

Absolutely precise numbers must have p = infinity.

Can you specify such datatype?

DROP TABLE YourTableName

CREATE VIEW dbo.YourTableName

AS

SELECT ID, COUNT(*) as IDCount

FROM dbo.SourceTable

GROUP BY ID

GO

SELECT * FROM dbo.YourTableName

You don't need all this hassle at all.

Update dbo.UserTable

Set B=@B

Where A=@A

That's it.

If there are no rows with A=@A no rows gonna be updated anyway.

And, yes, get rid of...

Replace the table with a view.

"DTC" means "Distributed Transaction Coordinator".

It must be on to perform distributed transactions.

Noel pointed on it in the very first reply.

rlively,

I hope you don't have problems with answering the question what's the weight of the feather on your scales if scales display 0.0 lbs.

And ypo not gonna have problem with...

Oooops!

Suckers shitted their pants...

Again!

The matter of fact - you both have nothing to answer on the simple question without humiliating yourself.

You may want to take time to explain what is the actual weight when weights display 0.0 lbs.

actual weight of -0.1

Wow, negative masses went into the play...

Dumb goes dumber.

If procedure length exceeds 4000 characters and linked server name is after 4000th character this won't work.

David,

start from zero.

If scales show 0.0 lbs it means that actual weight is...

Between -0.1 and +0.1?

Yeah, right.