Bruce W Cassidy (2/15/2009)

---

Jeff Moden (2/15/2009)

---

Not even close... in no way is Oracle even close to SQL Server or vice versa. Let's start with the basics, like returning a...

sumit-saini (2/15/2009)

---

i had tested this code in sql 2000

SELECT id,

days,

days - COALESCE((SELECT max(days)

...

400 Million rows? Consider partitioning that bad boy.

I'm sure there's a better way than the code I modified to go from 2k to 2k5... I haven't nailed down all of the new system views that came with...

Nice job, but recursion is actually slower than a cursor.

Heh... simple... the software was the very fabric of their business {visibly and audibly gagging at the terrible pun} 😛

... and, no.... again, I don't need to know how to solve the problem... I've done it at least a half dozen times with the "running total update" and once...

Bruce W Cassidy (2/15/2009)

---

[font="Verdana"]Okay, not exactly sure this is related. I await correction with trepidation. However...

In a company that shall not be named for which I had the...

GilaMonster (1/24/2009)

---

Jeff Moden (1/24/2009)

---

To make a longer story shorter, I normally try to write gender agnostic replies when I don't know someone and, one day in a response to "ggraber",...

So... are you saying a...

3' door is $500

4' door is $700

5' door is $900

6' door is $1100

???

DateAdd or not, the op hasn't identified what happens when you exceed 59 minutes and 59 seconds. If the duration in seconds equals two days, should the answer still...

Lynn Pettis (2/9/2009)

---

Each has its place, neither is actually better than the other for most applications. You get into the niche areas, that no longer becomes the true. ...

Perry Whittle (2/9/2009)

---

Oracle is by far the most powerful and flexible of the two.

In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers...

Steve Jones - Editor (2/9/2009)

---

SQL Server = Oracle = DB2

Maybe not ==, but each has things the other doesn't and for 99% of us out there, any of them will...

The real key here is... you shouldn't have jobs that run that long nor get "stuck". Find out what the root cause is and fix it. Chances are,...