Paul,

The problem we are having is that the OP is apparently dismissing everything without considering it in context. Yes, I have tested your devils advocate position and if you...

I'll accept the devils advocate position. But, can you make it fail when the optimistic concurrency features are not in use.

At this point, we actually don't know what transaction...

UBD -- User Brain Damage ...

noeld (5/8/2009)

---

Julius,

Coding this way ( with exists ... ) is NOT needed at all.

Set up a primary key and if there is a collision handle the error accordingly.

Leave locking...

Florian Reischl (5/8/2009)

---

The (first)...

Well, nothing wrong with a Masters by course work, that was my MA as well. Trust me, though, there was plenty of research work involved outside of the classes....

This:

begin transaction

select @rows = count(*) from dbo.SomeTable where SomeID = @SomeID;

if @rows = 0

insert into dbo.SomeTable values (@SomeID)

commit transaction

WILL NOT PREVENT two sessions from entering the...

Roy, can you post the exact error messages you are getting please.

Roy Ernest (5/8/2009)

---

Not all Indians are Mor**s like him with a MSA degree (I know MSc but not MSA) ...heheheh Me, I am an Indian with just one Bachelors degree...

I'd have to do some searching, might be in that thread he started when he mentioned he wanted to get his PhD, that the M.C.A. is a Master in Computer...

RBarryYoung (5/7/2009)

---

Lynn Pettis (5/7/2009)

---

The really sad part, he is probably working on an off-shore project for some sap company here in the US that thinks they have someone with a...

The really sad part, he is probably working on an off-shore project for some sap company here in the US that thinks they have someone with a Masters degree working...

RBarryYoung (5/7/2009)

---

Lynn Pettis (5/6/2009)

---

I refuse to post a link, but I really want to know what our favorite PhD candadate learned while in school for his current degrees.

I'm also curious...

karthikeyan (5/7/2009)

---

Lynn Pettis (5/6/2009)

---

karthikeyan (5/6/2009)

---

I tried the below code

DECLARE @Fixed1 decimal(8,4), @Fixed2 decimal(8,4), @Fixed3 decimal(16,8);

SET @Fixed1 = 5444.32;

SET @Fixed2 = 12121.03; <-- Problem is here. decimal(8,4) means you...

Really, and you know...