Jeff,

Code wouldn't show it.  My rememberance of this may be rusty so more knowledgeable folks should please jump in if I mis-state this, but internally, for each row, the fixed...

I can't speak for what corporations should or shouldn't do because in the end, it all comes down to what people should or shouldn't do.  In some cases those people...

The 'group by' clause should go after the 'where' clause.

INSERT INTO PHONE_NUMBER_LIST (PHONE_NUMBER,PHONE_MODEL,LANG_PREF)

Based on basic relational theory, there's no guarantee that 'select *' will always bring columns back in the order defined.  The ordering of columns in a relational table should have...

Why would you want to do this?  Normally, the column order in a relational database should have no meaning.  You select columns in the order you want to see them. ...

How are you joining the 2 tables?  There doesn't appear to be a common data element.

Did you do a complete overwrite, or did it do an upgrade?  Are your other databases gone or did they upgrade.

I don't believe you can back up a 2005 database...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CREATE PROCEDURE GetLatestDate

(@UserName VARCHAR(50)

AS

SELECT Max(Deadline)

FROM CustomerItems

Check the parens on the length subtraction.  I think it's trying to subtract 10 from the acct_id, not the length).  Maybe should be:

(Len(acct_id)-10)),

Use the '+' instead of the '&' as the concatenation operator.  That should get you pretty close.

Read up on float before you decide.  Float is an "approximate" data type and not always the best choice for the manipulation of real money.  I'd use numeric and specify...

Unless you specifically limit it, the SQL Server will take whatever memory it needs, up to and including everything the server has.  If you have a lot of other things...

You, Sir, are a fine and shining example of the best of this forum and I owe you at least a beer if we meet up at a conference.

Thanks a...

For SQL Server 2000, you can use sysobjects but not sys.objects.

The NULL problem probably shows up because you have 'quoted_identifiers' turned on so anything in double quotes is parsed as...

What error message are you getting?  There are new functions in SQL Server 2005 that won't be backward compatible for SQL Server 2000.

Can you post the first few lines of...