Sounds tempting, but I'd have to miss the first 2 sessions and spend 10 hours on a bus for the round...

Welsh Corgi (1/14/2016)

---

Phil Parkin (1/14/2016)

---

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your...

What's the problem?

SQLRNNR (1/14/2016)

---

Luis Cazares (1/14/2016)

---

Ed Wagner (1/14/2016)

---

BL0B_EATER (1/14/2016)

---

Grant Fritchey (1/14/2016)

---

Ed Wagner (1/14/2016)

---

Phil Parkin (1/14/2016)

---

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age...

wrightyrx7 (1/14/2016)

---

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...

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 the way,...

Disgusting

Phil Parkin (1/14/2016)

---

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as David Bowie....

Ed Wagner (1/14/2016)

---

BL0B_EATER (1/14/2016)

---

Grant Fritchey (1/14/2016)

---

Ed Wagner (1/14/2016)

---

Phil Parkin (1/14/2016)

---

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 -...

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 (SELECT T3.SMN_DATEC-1...

sqlnewbie17 (1/14/2016)

---

If my result set has a million rows wouldn't a case statement be very slow than a where clause.

Is there a better way of doing this.My environment is sqlserver...

Once you get the splitter, you just need to pivot the data.

CREATE TABLE #SplitTest( String varchar( 8000));

INSERT INTO #SplitTest VALUES( '111#222#33333#44#555#66');

SELECT MAX( CASE WHEN ItemNumber = 1 THEN Item END)...

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 END_DATE,

...

You just need to change the condition from the WHERE into a CASE statement in the column list.

--From this

SELECT ColA,

ColB,

ColC,

...

Orlando Colamatteo (1/13/2016)

---

NineIron (1/13/2016)

---

I'm running a procedure that I received from a vendor and I got a maximum recursion 100 error or something like that. So, this means that it...