Thank you very much.  I knew the answer was in a subquery but couldn't work it out.  I was trying case/else in the select statement and subqueries in the where...

The semi colon ( is used to delimit email addresses within the @to parameter in xp_smtp_sendmail.

This is cut from a SP I use, names...

In Enterprise Mgr, right click the table, and choose Design Table.  With the Design Table form open, go up to the tool bar and click the 'Table and Index Properties'...

The last post by blade is exactly what you need to do if you're using Outlook.

Or try SMTP mail.  Job Step 1 executes whatever.  On success it quits reporting success. ...

Instead of:

Dim exdoc as Excel.Application

Set exdoc = new Excel.Application

try

Dim exdoc

Set exdoc = CreateObject("Excel.Application")

and don't forget

set exdoc = Nothing

Put an index on bloodtype.  Even if its only temporary to get your update done.  You might then try updating everything to GroupA, then test and update the other groups. ...

When defining the import text file, choose the transformation button and tell it to ignore the last column.  Select ignore on the Source column.

Google "xp_smtp_sendmail".  Its an extended stored procedure that uses SMTP for mailing from SQL Server.  Its a beautiful thing.  You'll never need a MAPI client on your SQL Server again.  There...

Don't change the account in EM.  Go to the Computer Management MMC and stop/change/start it there.  Are there any errors in the Event Log?

I have had issues like this when the package is created on my client that is at a different service pack level than the server the package is saved on (and...

If the bottom line is getting the result set back to the client quicker, maybe you need to build some indexes to assist this procedure.  Or maybe the indexes you...

Similar to the last solution of adding the final row delimeter yourself, I copy text files to a staging folder on the sql server using xp_cmdshell.  In the copy command...