If anyone does do any testing of these methods, please post the results to this thread. I'm curious as to the outcome of this. Otherwise, I'll try...

No problem, glad we could help.

I'm referring to basic data cleansing. For example

The first query will show you that Michael Jordan has a name Mismatch with Mike Jordan based on DOB and Zip Code....

Do you not have any unique identification field for the patients? Usually in cases such as these, you would have a unique identifier such as PatientID, or PatientNumber that...

If you're asking how to ensure that updates coming from different sources go through one at a time, you can use transactions. That said, I don't believe you need...

In case anyone else is wondering after reading this (I was and decided to look it up rather than ask), here's how triggers that perform inserts affect these:

From BOL:

SCOPE_IDENTITY and...

Take a look at the PIVOT command.

http://technet.microsoft.com/en-us/library/ms177410.aspx

Yeah, I was 90% sure it wasn't before, and now I'm almost positive it's not. It made no sense that it would be, I just couldn't understand how the...

Lack of Quotes.

select * from universal where name = 'drill size ''9X10'''

I'm fairly sure you can't do what you're trying to do because executing your dynamic sql will open a new connection under which the virtual inserted/deleted tables do not exist....

I want to update a record, if the record count of another table equal to 1. How can i achieve this.

...

Getting back to this, the problem is now resolved. I'm still not sure what the issue was precisely, but today, to fix some other issues I was having, I...

ramadesai108,

How many rows in your final result set? 45 minutes seems like an awfully long time. Also, what is that case calculation supposed to show? ...

Cursory attempt to stop the thread from falling into the gutter = failure. 😉

This is integer arithmetic. ItmRecvdYR1 - ItmRecvdYR2 is less than ItmRecvdYR1, ie (10 - 5) / 5 = 0.

By multiplying one of the values in this part of...