I hate cross posting...

Anyway, like I said on the other forum, the correct date format number is NOT 103... it's 104. Check out Books Online under CONVERT.

As someone said above, date format #103 is NOT valid for this style of date. Check Books Online under CONVERT... the style you are looking for is style #...

No... cannot change the limit in SQL Server 2000.

Yes, you can work around it... take a look at "Expanding Hierarchies" in Books Online for details.

Never tried it because I just haven't had to do it. However, with...

Sorry, Terry... I don't know enough about the client known as SSIS to flip a nickel. I'm just assuming (bad thing to do, I guess) that it has some...

Misnomer would be correct... client could/will, indeed, pick it up as a "failure" because some error message as you said. Of course, that should be handled...

Loading the table...

Then, you need to do as I said... check out the "What's New" section of each release on the Microsoft website.

If you really have to copy the whole table, then you do not need deletes and you don't need the transaction. Insert into a new table... when you have...

Yeah... mistakes like that would certainly do it... I thought you were talking about something symptomatic with using WAITFOR even though you'd used it correctly...

Like everything else, it depends...

If you just happen to forget that a column may have times on it, BETWEEN is not a good thing because you may be missing a...

The transcender tests are representative of what the real tests will be. The real tests, as you know, are to test if you know enough to deserve the certification....

... and, if you're really smart, do a backup first.

You will need to use some form of dynamic SQL...

DECLARE @TableName SYSNAME

SET @TableName = 'sometablename'

EXEC ('CREATE TABLE '+@TableName+' put rest of create here')

I guess I'm really worried about why you...

Going to another site for your files is a PITA... it would be much better if you'd just attach the files to your post.

The files are JSP files... I'm a...

Replace this part of the code...

/*

EXEC EDI..prcCreditCardCampaign '2008-01-14 00:00:00:000','2008-01-18 23:59:59:999'

EXEC EDI..prcCreditCardCampaign NULL,NULL

*/

IF OBJECT_ID('prcCreditCardCampaign') IS NOT NULL

DROP PROC prcCreditCardCampaign

GO

CREATE PROC prcCreditCardCampaign

@FromDate DATETIME = NULL,

@ToDate DATETIME = NULL

AS

SET NOCOUNT...