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

Apparently an orange turd with a straw comb-over has got a really important job somewhere. I can't quite understand it myself.

If they ever install that in our place, I'm doomed.

Yes this is possible, as demonstrated below. But, this is an extremely simplified example that may not be appropriate for your situation. If you post some sample data...

Gary Varga (11/1/2016)

---

It seems a little worrying how many will not use the command line. I am not referring to your average citizen but your average IT professional. I have...

One barrel...