Koen Verbeeck (1/15/2015)

---

ChrisM@Work (1/15/2015)

---

or resolve it in the string:

+ '

FROM employee m

LEFT JOIN shiftdetails b ON m.empno = b.empno

where b.shifttype = ''' + @shifttype +

...

or resolve it in the string:

+ '

FROM employee m

LEFT JOIN shiftdetails b ON m.empno = b.empno

where b.shifttype = ''' + @shifttype +

''' GROUP BY...

Swap

Lynn Pettis (1/14/2015)

---

Don't worry about it. Some people...

Very well done mate, richly deserved.

Aaron N. Cutshall (1/14/2015)

---

Yet, not surprising when you consider that the parent table has 1.85M rows, the child table has 7.5M rows, and the validation table has 54K. The...

Aaron N. Cutshall (1/14/2015)

---

Chris' solution works well in environments with low to medium data volume, but in the very high data volume environment I have it's too slow. I'm...

No, it's version-specific. The code runs on 2008+.

Aaron N. Cutshall (1/13/2015)

---

ChrisM@Work (1/13/2015)

---

There are two issues here which might be causing some confusion.

Firstly, the FROM list of your query, which looks like

SELECT ...

FROM parent

LEFT JOIN child to...

There are two issues here which might be causing some confusion.

Firstly, the FROM list of your query, which looks like

SELECT ...

FROM parent

LEFT JOIN child to parent

INNER JOIN grandchild to...

SELECT tp.*, s.acct, s.enterDate, s.processDate

FROM temp tp

INNER join staticTable s

ON tp.acct = s.acct

WHERE

s.enterDate NOT IN (@conversiondate, @termDate)

OR -- if s.enterDate IS equal to @conversiondate or @termDate...

SAMDEV (1/12/2015)

---

Actually i have hard-coded value for @Rec but it gets calculated for each record being inserted from source table into destination.

For this purpose I cannot directly insert values from...

SAMDEV (1/12/2015)

---

Actually i have hard-coded value for @Rec but it gets calculated for each record being inserted from source table into destination.

For this purpose I cannot directly insert values from...

SAMDEV (1/12/2015)

---

I am debugging a stored procedure. During this I am executing some insert statements on a table which are created from within stored procedure only.

Now, during my debugging...

You might want to read about table aliases - they will make your code much easier to read:

SELECT

12-COUNT(a.PatientID) AS NumberOfPatientsCurrentlyEnrolled,

a.CourseID,

l.LocationDesc,

c.CourseDate

FROM dbo.tblCourses c

INNER JOIN dbo.tblLkup_Location l

ON c.Location_ID...