Hello 🙂

Thanks for your reply I didn't think anyone was coming back to me on this.

Yes emails on weekends are fine the managers can just pick them up...

John Mitchell-245523 (7/21/2016)

---

Or you could go with 13, 26 and 39 weeks, to make it more likely that the manger will be informed on a working day. Start with...

Hi Jeff,

Many thanks for...

John Mitchell-245523 (4/21/2016)

---

Something like this...

WITH Departments AS (

SELECT *, d.DepartmentName,

CASE WHEN p.PDT_ORG_4_CDA LIKE 'X%'

THEN p.PDT_ORG_5_CDA

ELSE p.PDT_ORG_4_CDA

END AS DeptCode

)

From stage_chris21.PSDET p

INNER JOIN Departments d

ON p.[DeptCode] = d.DepartmentCode

... or this:

SELECT *,...

John Mitchell-245523 (4/21/2016)

---

You can't join on a column alias. Either wrap the whole SELECT statement in a CTE or subquery, or repeat the whole CASE expression in your join...

GilaMonster (4/21/2016)

---

IIF was added in SQL 2014, but in earlier versions you'd use CASE (IF is control flow)

CASE WHEN [PDT_ORG_4_CDA LIKE 'X%'

...

John Mitchell-245523 (4/12/2016)

---

No, a primary key is a property of the table, not of a particular query that you execute...

Luis Cazares (1/14/2016)

---

I'm not sure what's the problem. The code should be working and there's no missing parenthesis. That's just another reason why I hate Oracle.

Maybe someone else can help.

By...

Luis Cazares (1/14/2016)

---

wrightyrx7 (1/14/2016)

---

Luis Cazares (1/14/2016)

---

Oracle does not use TOP(n). One alternative is to filter by ROW_NUMBER().

SELECT T1.*,

(SELECT END_DATE

FROM...

Luis Cazares (1/14/2016)

---

Oracle does not use TOP(n). One alternative is to filter by ROW_NUMBER().

SELECT T1.*,

(SELECT END_DATE

FROM (SELECT T3.SMN_DATEC-1 AS...