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

Heh... "Flat file cleanup on aisle 5"!

Are you all set, Kirk? Did Mark's post do what you needed (looks like it but thougt I'd double check)?

No, no... it won't fail if the IGNORE DUPLICATES option is turned on for the unique index. It will just give a warning that at least one duplicate was...

You have no error detection code and no rollback code... and SET XACTABORT has not been turned on to make up for it...

... so why do you need a transaction...

I've seen requests like this before and they always puzzle me... it would appear that the name should be the primary key in this case. Yet, you have more...

Not sure what you mean... how?

If you do it right, more than you can possibly imagine...

The following URL has a lot of good information about Excel spreadsheets and ADODB... perhaps it'll have what you're looking for...

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Also, not sure why you'd bother pinning it... it will certainly fit in cache.

17GB seems a bit large even if it's a Terabyte instance... if folks are using triangular joins, cursors for large record sets, temp tables for large record sets, views of...