Assuming that Account_Established_Date is defined as a datetime datatype, what happens when you use this:

isnull(A.Account_Established_Date,gedate())

Here is another way to do what you are trying to accomplish. It is only a framework, but you should be able to adapt it to your needs.

declare @CutoffDate...

Jeff Moden (11/11/2008)

---

Lynn Pettis (11/11/2008)

---

Jeff Moden (11/11/2008)

---

Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. Seems like...

In a data warehouse environment indexes are even more important. They may get in the way of the nightly loads, but thats when you drop, load, and rebuild.

I've told you what I need. You need to read...

Veterans Day, my brain is taking a slight break.

If it is an 'I' then 0 else 1.

Jeff, been try to help him, but we can't even get him to help himself. I have pointed him toward your...

First question I have, do you have a backup of the msdb database? If not, why not.

If you don't, start reading BOL (Books On-Line). You should be able...

Sounds like a good use of a Tally table. Read the following article, it should help you out. If not, let us know.

http://www.sqlservercentral.com/articles/TSQL/62867/

I have nothing against which to run your script. You haven't provided us with the tables or sufficient test data to do anything except guess.

This is actually a continuation of the following thread:

http://www.sqlservercentral.com/Forums/Topic600148-338-5.aspx#bm601093

Seconded -- to agree with a motion presented during a meeting, usually resulting in a vote on the motion. Check Robert's Rules of Order.

Bingo. Then add a little bit more for cushion. If you determine that the log should be 5 GB, make it 6 or 7 GB to add some...

Okay. That explains why I have never heard of a natural join. I've never had the opportunity to work with Oracle.

I want you to actually read the article I keep telling you to read. I want you to help us help you. If you can't provide the necessary...