I do have to say I liked Oracle's CREATE OR REPLACE. If the database object (view, stored procedure, function) already existed, it replaced it and if it didn't exist...

Not enough information. Please read the first article I reference below in my signature block and follow the instructions on what and how to post the information we need...

Been 5 days and nothing from the OP. Guess it isn't as urgent as he said.

Also, since SQL Server 2005, the date/time of when database objects are modified is now captured in the new system views.

Also, it would assist others if you could post the DDL for the tables including indexes and the actual execution plan for the query as a .sqlplan file.

See the second...

Honestly, no. The code is in desperate need of being properly formatted before I could do anything. It was hard enough to just find the joins in the...

You can't create an indexed view on that query. Indexed views can not contain outer joins.

DECODE is a powerful function in Oracle. While I worked in it I saw it used many times and the Oracle developers I did talk to love it. ...

PaulB-TheOneAndOnly (4/19/2012)

---

Lynn Pettis (4/18/2012)

---

PaulB-TheOneAndOnly (4/18/2012)

---

MySQL? do you realize this is the Oracle...

Jeff Moden (4/18/2012)

---

Shifting gears hard to the opposite side of the spectrum, have you folks been watching Wayne Sheffield's blog? He's done some awesome testing against some of the...

Can't really guide you, but I can tell you, you should do some research in Books Online to start.

Not sure, I haven't looked into much, but you might check out Policy-Based Management.

Revenant (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

capn.hector (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

Lynn,

My wife is a special education teacher with a lot of training and...

I am going to say yes,...

One thing I'd like to stress that dwain.c mentioned above. Do not be afraid to fail. You actually learn more from your failures than your successes. It...