Mr. Jan Michaels,

Thanks for your help.

One point is was making was that in all the examples I found on the net, the following lines confused me no end:

[font="Courier New"]/* Configuring...

Ach so... No takers eh ?

OK Fixed it.

1. Lack of documentation

As I mentioned, all references to Microsoft documentation regarding CDOSYS given in the various articles found on the net systematically...

Outlook is not installed on the SQL Server machine.

Even if I install it, I will always have to run.

Not using Outlook avoids an unecessary dependency.

And no, I am not...

And I forgot to mention it:

WITHOUT using SQLMail.

Regards

Er, I hope it is not a dumb quesiton, but I do not see what go again over just running the stored proc...

Your first SELECT simply echoes back to the console the values of the parameters you supplied in the call to the stored procedure.

declare @cmd varchar(2)

set @cmd = 'Hi'

select @cmd cmd...

I could not replicate your problem. I tried the following:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Table1]

GO

CREATE TABLE [dbo].[Table1] (

...

The contents of the database tables - unless encrypted - would help in understanding what the "confusing" table names and column names really mean. And the "confusing" part also applies...

|Hola Pablo!

In Québec, Canada, the word "innocent" means, in addition to standard French "not guilty", in our version of slang it means someone not very bright.

Jeff Moden (4/4/2008)

---

In the at the very top of the "left window" for each post (just above where you got my posting stats from), just click on my bolded name......

You can send an email if you want. I need the PM's I have but there's no way to download 100 enmasse and they won't give me more...

The first SELECT is NOT using only one CAST operation.

Since the...

What I' was a little bit worried about is that the myTempSelectionList table would appear to become a hot spot and possibly a source of deadlocks unless you're very careful...

Clearing myTempSelectionList.

Let's say there is a button on the GUI to print a bunch of specs sheets.

After Crystal Report has shown on screen the printout, returning control to the application,...

Matt,

I stand corrected. Thank you.

I have not made the switch to 2K5 and do not plan to, if it is at all possible to jump directly from 2K to 2K8.

Regards