New York

Ed Wagner (11/18/2016)

---

BWFC (11/18/2016)

---

I've not tried it yet but it's definitely on the agenda. The next thing on the curing list is a ham. Hopefully I've not left it...

Soon

I've not tried it yet but it's definitely on the agenda. The next thing on the curing list is a ham. Hopefully I've not left it too late to...

ChrisM@Work (11/18/2016)

---

Eirikur Eiriksson (11/18/2016)

---

BWFC (11/18/2016)

---

TomThomson (11/17/2016)

---

BWFC (11/16/2016)

---

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently...

Eirikur Eiriksson (11/18/2016)

---

BWFC (11/18/2016)

---

TomThomson (11/17/2016)

---

BWFC (11/16/2016)

---

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try...

TomThomson (11/17/2016)

---

BWFC (11/16/2016)

---

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar...

I'll probably go that way myself. The OnError event handler writes to a table and sends out an email with the details so I can capture what went wrong....

Thanks Phil. It's really frustrating that it doesn't continue to log.

There is an OnError event handler in place and it's that that stops the job. It does...

Query 5 will bring back...

CREATE TABLE #temp_sp_who2

(

SPID INT,

Status VARCHAR(1000) NULL,

Login SYSNAME NULL,

...

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar which was...

Click

Irfan.Baig (11/7/2016)

---

Hello Dear Mike,

I think we can also remove duplicates using simplest, easiest and better way without using temp table/s logic:

WITH CTE_InsurancePolicy AS (

SELECT PolicyId, FirstName, Surname, PolicyStartDate, PolicyEndDate

,ROW_NUMBER() OVER...

Parrot