NineIron (9/11/2015)

---

I need to update the Denominator column in one row with the value from the Numerator column in a different row.

For example the last row in the table is

c010A92NULL

I...

mohelsheikh (9/10/2015)

---

Thank you Sean Lange

I am inserting the new records one by...

Lynn Pettis (9/10/2015)

---

Alvin Ramard (9/10/2015)

---

Lynn Pettis (9/10/2015)

---

It isn't that the questions are getting worse, I really think it is that the people working against the databases really have no business...

You can't delete a post. It would be best if you put your question back and included...

robert.chipperfield (9/10/2015)

---

Sorry to hear that - we've not seen a repeat of the same packet loss we were seeing since it was fixed, so it feels like it must be...

lawrence.simpson (9/10/2015)

---

Apologies rookie mistake

This is my SQL

SELECT

R.[CARE_ID]

,min (T.[Treatment start date])as...

Ed Wagner (9/10/2015)

---

Uh huh. There are...

Maybe there are rats chewing on the wires. The performance has been steadily getting worse over the last few days. As of today the site is basically unusable for me....

I wonder if anybody responds with "I don't actually write any code, I just copy and paste from SSC or SO". :-D:-D:-D

Awesome job posting ddl and sample data. And extra bonus points for posting the desired results!! The only thing missing is an explanation of how you got there. I can...

lawrence.simpson (9/10/2015)

---

Sorry I should have parsed to make sure it was grammatically correct. This seems to work now

select A.CAREID

,A.referraldate

...

biscribbler (9/9/2015)

---

Hi,

Below is my proc which updates using joins.

Though I have provided only two tables, I am updating almost all tables.

I am logging the depId and Table which has failed,...

Very cool.

Boy this sure looks familiar. http://stackoverflow.com/questions/32481405/trigger-fire-on-each-inserted-row-to-insert-into-remote-table

I will post the same issues.

Your trigger is not set based and will NOT work when there is more than 1 row being inserted.

Most importantly...

You know that when you don't bother to put in any effort into providing details it ends up coming across as though you want somebody to...