Sorry for not trying the sp_executesql with a temp teable before posting. I have used it with other scalar variable types, and made a dumb assumption that it would work...

You could declare the table variable inside the dynamic sql and use it as an output variable from a call to sp_executesql, and pass in your locally declared table variable.

Tim...

This is probably not exactly what you wanted, but why not make the email a computed column? It looks like that is what you are trying to do except with...

You can accomplish what you want to do with some careful short circuiting in your where clause, and using grouping. EX:

SELECT * FROM TABLE

WHERE (@fldProoferLogID IS NOT NULL...

Brian take a look at this article. I was having problems until I did this :

http://support.microsoft.com/default.aspx?scid=KB;en-us;270061&

Tim C.

//Will write code for food

There are several benefits to my solution that I posted earlier :

1) COM+ Transactions

2) Asynchronous - allows execution to return back to the calling stored proc IMMEDIATELY when queued

3)...

I do something similar to what you are attempting to do. I am using "Loosely Coupled Events" in COM+ with MSMQ Queued Components. This allows me to call a VB...

Also take a look at:

How to Write CGI Applications in Visual Basic

http://support.microsoft.com/default.aspx?scid=KB;en-us;239588&

Tim C.

//Will write code for food

Is there any way at all that anyone knows how to do this? Myabe a TRACEON? a configuration option? etc....

Tim C.

//Will write code for food

The actual method for the CDOSys object to attach a file is AddAttachment. As in :

EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', 'http://someuri/picture.gif'

OR

EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', 'C:\file.txt'

Hope that...

I think the problem is a matter of precision. From the SQL BOL :

"datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one...