Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via the

WHERE NOT EXISTS (SELECT source INTERSECT...

I cannot understand this.

Please post your...

ffarouqi (1/18/2016)

---

Lolz...that is already there at the top of this post. Yes, the id is different, as I was using my friend's account to post it, but now I am...

ffarouqi (1/18/2016)

---

Fyi...we've used isdate to eliminate the non-date stuff, but the problem still persists. Kindly, let me know which piece of code is causing the issues, because if I run...

qbrt (1/18/2016)

---

I am in the process of transitioning our eCommerce database to the declarative model of SSDT to move the database development process into our CI pipeline. Using idempotent MERGE...

tusharchpatil (1/18/2016)

---

Hi All,

If i used select * from emp where rownum < 5;

I am getting the correct output of table ie. 4 rows.

but it is not working on rownum >...

Dreamsz (1/18/2016)

---

Hi,

I am facing an issue as described below.

select * from dbo.xyz

where a in ('a string of multiple values')

and <some condition>

and cast(a as datetime)=cast(b as datetime)

a is varchar(50), and...

ROW_NUMBER() is your friend here. Something like:

select rw = ROW_NUMBER() OVER (PARTITION BY KEY_NO ORDER BY DATA)

My pleasure. Glad you got it working.

Have you considered putting 'lag' in your CTE, to get 'previous' price and then selecting from your CTE if price <> previous price?

Welsh Corgi (1/15/2016)

---

Phil Parkin (1/15/2016)

---

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No, you don't....

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No, you don't. You can use...

Are you referring to this type of table variable?

The older type of table variable is not in-memory. Nor is it good for holding large quantities of data.

Welsh Corgi (1/14/2016)

---

I execute the following Query:

INSERT INTO POSTAL (ID,Latitude, ID.Longitude, CityTownshipID, CountyRegionID,StateProvinceID,CountryID)

SELECT ZipCode, Latitude, Longitude,CityTownshipID , CountyRegionID, StateProvinceID, CountryID

FROM Postal_Codes_Import

WHERE NOT EXISTS (SELECT *

...

Welsh Corgi (1/14/2016)

---

Phil Parkin (1/14/2016)

---

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your...