Actually, according to the scores and standings page...

Jeff Moden (11/12/2008)

---

I...

Nope. Take a close look at the code. Everything appears to be using user-defined types. Those all need to be the base types for me to do...

Here is a slightly different version doing the same thing.

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

...

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