qbrt (1/19/2016)

---

Phil Parkin (1/19/2016)

---

qbrt (1/19/2016)

---

Phil Parkin (1/18/2016)

---

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

alex.sqldba (1/19/2016)

---

Afternoon All,

I am just trying to get in line a great many SSIS packages that either might be used, might not be used, are duplicated in terms of purpose,...

qbrt (1/19/2016)

---

Phil Parkin (1/18/2016)

---

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...

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...