We use

DATEADD(d,DATEDIFF(d,0,T.ApptDate),0) to get the date with time set to midnight.  We have found that CAST and CONVERT are way too slow when applied to large subsets of data.

Terri

We always add the Add_Date, Added_By, Update_Date and Update_By columns for audit trail purposes.  Add_Date and Update_date are data type Datetime.  We also use Version (datatype integer) to determine how...

Do you have Visual Studio 6 Sp6 installed?  If so, this may be your problem -  I encountered this problem yesterday and solved it by replacing the MDT2DF.DLL (version 2.0.0.9586)

from...

If the only purpose of the counter is to make the index on employeeid, school and date unique why not use the identity field as part of the index to...

Just a comment on the subject of name parsing.  The last word in the string is not necessarily the surname.  For example, the surname "Saint Raymond" is 2 words.  Also,...

Never mind, the SQL task had the wrong connection.  It works now, if the Excel file exists.  Is there a way to check if the file exists before dropping it? ...

Create a SQL task who’s existing connection is the excel spreadsheet. Remember, the sheet “screwup” is treated like a table so you must drop it and re- create it, so...

Not an answer to your question but your parsing algorithm fails for names like mine: Terri Santa Coloma, where Santa Coloma is my last name, no middle name.  It also...

I wish that you would display the first few lines of the message in the Community Update email as you did in the past.  This would better enable me to...

Thanks for the quick responses.  The article by Andy Warren was particularly helpfull.  I've decided to use the SET CONTENT_INFO solution for now.

Terri

tsanta@lsuhsc.edu