ScottPletcher (7/23/2015)

---

Lynn Pettis (7/23/2015)

---

ScottPletcher (7/23/2015)

---

...

I do say never. Never use ISNULL() in a WHERE or JOIN -- it's never needed, and it can be very harmful.

Never specify a unicode...

Sean Lange (7/23/2015)

---

Ed Wagner (7/23/2015)

---

Sean Lange (7/23/2015)

---

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I...

Ed Wagner (7/23/2015)

---

Lynn Pettis (7/23/2015)

---

Ed Wagner (7/23/2015)

---

Sean Lange (7/23/2015)

---

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink...

ScottPletcher (7/23/2015)

---

...

I do say never. Never use ISNULL() in a WHERE or JOIN -- it's never needed, and it can be very harmful.

Never specify a unicode literal unless you...

ScottPletcher (7/23/2015)

---

Here's an alternate method: with only two columns, I'd probably skip using CROSS APPLY:

DECLARE @starting_year int

SET @starting_year = 2012

SELECT subquery.ID, e.NAME, subquery.Year, subquery.Max_Date

FROM (

SELECT ID,...

From this in the FROM clause:

CROSS APPLY (VALUES(DTE.StartDate),(DTE.EndDate)) x(EnrollmentDate)

Please explain how an ENDDATE can be less than the corresponding STARTDATE.

Ed Wagner (7/23/2015)

---

Sean Lange (7/23/2015)

---

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across...

ScottPletcher (7/23/2015)

---

Lynn Pettis (7/23/2015)

---

WayneS (7/23/2015)

---

Good luck with adding...

lsalih (7/23/2015)

---

Phil - I completely agree, I remember that and I appreciate it...

Here is the script:

Create table EMP

(ID INT,

NAME NVARCHAR(10)

)

insert into EMP values (1, 'JOHN')

create table EMP_INFO

(ID INT,

STARTDATE DATE,

ENDDATE...

Thinking you should have been a Dentist?

WayneS (7/23/2015)

---

Good luck with adding that index to...

WayneS (7/23/2015)

---

SQLRNNR (7/23/2015)

---

dweil (7/23/2015)

---

Who really cares if they are looking up the answer on the internet. The idea is to see how they would approach /solve a particular problem/solution. If...

Jayanth_Kurup (7/23/2015)

---

@Op instead of using temptables , you could try using recompile hint and see if the performance improves. Using a temptable just to avoid problems with the base table...

Here are the tables used in the FROM clause and the number times each is referenced:

Table Name ...