Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on a retainer for 5 hours a...

If everything is working fine without the NOLOCK hint why do you still want to use it? NOLOCK has the potential to get you "dirty" matches.

I'm not sure what you mean when you say some of your data or the other person's data is getting inserted? Do you mean that not all of the data...

Would something like this work?

update ...

from TableA a

join UpdatePool b on a.CustomerID = b.CustomerID

delete from UpdatePool

from TableA a

join UpdatePool b on a.ID = b.ID

select @RowCnt = @@ROWCOUNT

insert into...

Since you are comparing 3 columns and it doesn't appear to have any different about them you could use a function like binary_checksum to create a single value for the...

I have confirmed your results on 2008, 2008 R2 and 2012. Cache was not cleared.

You need to provide some DDL for this problem. How about some create table statements with actual column names and real data with expected results.

Do you use a scheduled job to refresh the test database? If so, then add a step to run your script. If you don't use a scheduled job how do...

This looks like a homework assignment or something. You need to look up how to do a join in a delete statement or using the EXISTS statement.

Next time you post a question like yours please try to include a sample create table statement along with some test data like my post back to you. This will...

Here you go:

create table ResetData (accountNumber int, MaturityDate datetime, ResetFreq char(3), Amount decimal(6,2))

insert into ResetData

values (123 , '20140331' , '1D' ,100.00)

,(123 , '20140331' , '1M' ,2400.00)

,(123 , '20140331'...

SQLRNNR (10/7/2013)

---

Steve Jones - SSC Editor (10/7/2013)

---

SQLRNNR (10/7/2013)

---

Not a Broncos fan. But I am hoping to see that offense score big every week. 700pts in a season seems...

I will be there...

Josh Freeman is the newest QB in Minn. I just need the Bears to start...

Can you provide some DML and some sample data with a required output? This will help you get an answer quicker.