texpic (3/13/2012)

---

Guess I didn't indicate the result I needed. Need the 0 in AuthAmount when Source = S to be updated to 100. It does not update.

Why did...

http://www.connectionstrings.com/%5B/url%5D

Why global temp tables?

I would be willing to help but first I need some sample data that I can use. I can't insert the sample data you provided. The columns do not match...

Could it be concurrency? If you have two processes calling this at the same time it is possible that the update fires twice but for the same value.

On another point...

Given the sql you...

So you do know that the people that help around here are volunteers right? You did not provide anything other than a 300 line proc. There is no ddl and...

This will explain far better than I can.

http://msdn.microsoft.com/en-us/library/ms190387.aspx

I would agree with your boss. Changing a left join to an inner join is not a good way to remove duplicates. It may in fact filter out data that...

Read this one, I think this what you are looking for.

http://msdn.microsoft.com/en-us/library/ms180026.aspx

DOH!!! After nearly...

What is the EXACT query you are running?

It would be a LOT easier to help you if...

An implicit conversion of '112' to any numeric datatype would not be a problem.

--edit: spelling.

There are a number of challenges you are going to face here. First it seems your Withdraw and Deposit are backwards?

Why have two columns? Aren't these all transactions that have...

ard5karthick (3/12/2012)

---

It has a Constant Format in which it will appear,

And it is 36 Bit not 16 Bit and Each Digits can be of HexaDecimal Value From (0 -9)...