Ed Wagner (4/6/2016)

---

Yeah, that was an interesting...

Would help if we also had your code to look at and see what you are doing.

And now the attitude arrives.

Greg Edwards-268690 (4/5/2016)

---

Phil Parkin (4/5/2016)

---

Luis Cazares (4/5/2016)

---

I constantly avoid that...

Just throwing this out there, but if you are deleting all the data from a set tables with RFI configured, you can delete the data starting at the lowest level...

Not necessarily. Someone else may come along at some future date, look at the solution provided and decide to see if...

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something I feel most of us haven't...

As my youngest daughter nears graduation from high school and I am officially single, I would consider moving for a job unless outside factors encourage me to stay here, in...

Try this:

with basedata as (

select

ProductCode,

Price,

ValidFrom,

ValidTo,

rn = row_number() over (partition by...

This is more like how I would do it and it allows for the temporal closed/open format Jeff showed above.

D E C L A R E -- spaces added to...

The following snippet is what I used to handle a deadlock issue we were experiencing of a process that updated a TableOfContents table. We found that this process was...

It has been a long time since I have dealt with MS DTC errors between servers. You need to check the configuration of MS DTC on both servers to...

Why not explain to us what your query is doing? Here, by...

Ed Wagner (3/31/2016)

---

Sean Lange (3/31/2016)

---

Ed Wagner (3/31/2016)

---

jasona.work (3/31/2016)

---

Sean Lange (3/31/2016)

---

BL0B_EATER (3/31/2016)

---

They got...

Wayne West (3/31/2016)

---

Lynn Pettis (3/31/2016)

---

Many years ago I worked for a company as a computer operator (paid OT) where you were paid one hour straight time for every 4 hours...