Here is a solution entirely based on SQL 2012 window functions, I left it a little long winded to make it easier to follow.

😎

USE tempdb;

GO

IF OBJECT_ID('tempdb.dbo.sales') IS NOT NULL...

Roust_m (6/10/2014)

---

Hi,

Just installed standard editon, put tempdb on SSD and configured buffer pool extension to SSD. Ran some production replay trace. Very slow. Eats a lot of...

Evil Kraig F (6/10/2014)

---

Sub,

What performance concerns are you worried about from the concatonation technique? You should see little to no performance difference for a concatonation technique vs. a more...

SQListic (6/10/2014)

---

Hi,

How to create insert statements of the data from a table for top 'n' rows. I know we can create using generate scripts wizard, but we can't customize the...

From the top of my head, it would be

😎

EXEC dbo.sp_update_job @job_name = N'Job_Name',@enabled = 0

GO

From the command line

sqlcmd -S server -d database -Q "EXEC dbo.sp_update_job @job_name = N'Job_Name',@enabled =...

TomThomson (6/10/2014)

---

a...

The Dixie Flatline (6/10/2014)

---

That's where we disagree. 🙂

When I set statistics time,io on for the JOIN solution, it gives the following results:

Table '#B558B379' Scan count 0, logical...

below86 (6/10/2014)

---

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years ago we...

TomThomson (6/10/2014)

---

As neither SQL nor T-SQL supoprts a complex number type, it's quite clear that the extended...

N_Muller (6/10/2014)

---

Is there a limit on the size of the strings on both sides of the '=' sign for string comparison? If I have two varchar(max) strings, will the...

What have you tried so far?

😎

subbubally (6/9/2014)

---

Hi Eirikur,

Thanks for your reply, i already tried this solution too, if we go by concatenation, there may be performance in future, that's the reason, i avoided...

You need a little bit of trickery here.

😎

USE tempdb;

GO

SELECT

(

SELECT

...

rockstar283 (6/9/2014)

---

IMHO, the simplest way is to restore a backup of production over the dev with replace unless the size is an issue. The second bird you hit with this...

Thanks for the explanation:-)

There is not much difference in the actual work though, the matching "old" values must be selected from the existing set, based on which ever matching criteria....