About naming parameters:

I have been using @pi_ prefix for "parameter, integer" and @ls_ prefix for "local variable, string".

I am one who uses very long stored proedures to say, process incoming...

About using singular names for tables:

Good idea.

That name is then suitable for constructs such as

ForEach Officer ...

Looks pretty sorry when it is

ForEach Officers.

I only installed SP 4. The version info is:

[font="Courier New"]/*-----------------------------

select @@version

-----------------------------*/

Microsoft SQL Server 2000 - 8.00.2050 (Intel X86)

Mar 7 2008 21:29:56

Copyright (c) 1988-2003 Microsoft Corporation

Standard Edition...

Well, I am confused.

Whatever happened to the concept that you cannot assign a result set to a scalar -- Should this not be barfed out at compile time in the...

Writing an article ... that would be my first ever.

However, I took all the information from others, such as Desiree Harris. Unfortunately, she had not explained about the weird-looking values...

Also,

Rechecked my code, yes sending a list of file names is exactly what my stored proc does. (Any new customer purchase order received through Electronic Data Interchange that is placed...

Forgot to tell you.

If it appears the stored procedure executes but that the actual e-mails appear not to be sent, SMTP handles throws them in the c:\Inetpub\mailroot\badmail directory.

Text body and HTML body will take whatever you put in the local string variable. A list of file names (separated by CHAR(13) should indeed do what you want.

And the...

Mr. Johnson,

Thanks for your remark about PRINT/SELECT statements still being relevant in some cases.

Regards

Never discount a "Newbie". They can teach making faces to old monkeys (OK, sounds strange, but this is a translation from French).

venkatesulu pointed me to an article on debugging...

Not having migrated from SS2K to SS2K5 yet,

The old way of doing things is to add the PRINT satetments (I prefer using SELECT).

Call your stored proc in the Query Analyzer....

Hmmm...

I do not remember where I read that, but apparently CDOSYS is much superior to CDONTS.

And I am getting confused here, is CdoNtsMail different from CDONTS ? A Web search...

Instead of just "never mind" ... whih turns this forum topic into empty junk, why not post your solution for the benefit of others and to avoid adding junk to...

I forgot to add that this is a coding style, NOT a "rule".

I am not sure if I understand your question, but I will try to answer.

Regarding the do not use BEGIN and END:

It just applies to the this case:

[font="Courier New"]CREATE myStoredProc

AS

BEGIN

-...