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

"In order to understand recursion, one must first understand recursion"

It's mostly used when some code calls itself either directly or indirectly. For it to work, you need to find a...