Putting aside ISNUMERIC and its issues I still don't understand why a CONVERT would work when selecting a field but not in the WHERE clause.

Is it possible that the comparison...

Can LIKE '%0-9%' be adapted if my data is like the following?

100.00

75.99

99.00

Yes it does. My apologies. I have overlooked the obvious....

CREATE TABLE Example

(

MemberID varchar(50) NOT NULL,

Email varchar(50) NOT NULL,

UNIQUE (MemberID, Email)

)

SQL server will generate an error message but it won't be a particularly friendly message. How to handle error...

Can you add the tab manually?

Try moving the file local to eliminate ony network permission issues.

See this:

http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/

Thank you both, that was very helpful.

All, thanks for providing code samples and suggestions. This is one of those situations where the code is working, the user is happy, but I have a feeling I can...

Chrissy321 (12/13/2010)

Alas no. Its six table with case and coalesce...

No my employer does not allow this which is why I post pseudo code and only hope for for pseudo answers.

Alas no. Its six table with case and coalesce logic.

Let me please amend this by saying I can use CTE since I am working in a 2005 environment but the proposed function would be referencing a linked 2000 database....

Hi George,

Its not working because you file is quite non-standard. Best bet is to get the file sent as straight csv or straight fixed width and with consistent use of...

Hi,

See the BOL subject sp_send_dbmail specifically 'sending an HTML e-mail message'. This will show you how to return multiple records and then insert into each record into one html table...

Thanks you for these links, this is just what I was looking for.

Now when I try to View T-SQL for the maintenance task I get the error on a different index.

Can anyone recommend a good script for this purpose?