Are you trying to restore the master database from a SQL Server 2000 installation?

Phil Auer (11/12/2008)

---

Thank you very much for the on-point answers.

Two follow-ups:

1. Is removing the inactive entries on a full backup an option (which I would want to NOT select) in...

There may be a better way, but I hope this helps:

DECLARE @test-2 TABLE

(ID INT, TXT VARCHAR (MAX))

INSERT INTO @test-2

SELECT 1,'A'

UNION

SELECT 2,'A'

UNION

SELECT 2,'B'

UNION

SELECT 3,'A'

UNION

SELECT 3,'B'

UNION

SELECT 3,'C'

declare @txt varchar(max);

select

...

Phil Auer (11/12/2008)

---

I have searched the web and cannot find succinct answers to the following questions:

1. Does a full backup in SQL Server 2000 remove inactive entries from the current...

As you are using Management Studio, correct, you need to go to the options tab and select overwrite existing. You may also need to change the destination location for...

If you have to have one stored proc in the Utilities database, then you will need to go with dynamic sql. I'd also look at writing your procedures so...

I had boolean logic hammered into me in a microprocessor design course/lab in college. Couldn't explain it well, but I sure do remember how it works.

Simple boolean error. Write the query to first return what you want to exclude.

After that, NOT the condition. If you expand that, you'll find that NOT(myLetter = 'A'...

Here is some test code for you to check out.

declare @SDate nvarchar(10),

@SDateNull nvarchar(10),

@DDate datetime;

set...

Appears that A.Account_Established_Date is not defined as a datetime, but perhaps nvarchar(10). Try this:

coalesce(A.Account_Established_Date, CONVERT(nvarchar(23), GETDATE(), 121))

I am assuming that in production you are running this against permanent tables, not table variables. If so, can you provide the DDL for the tables and the indexes...

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.