🙂 I'm usually looking for ways to disseminate my superiority...

You've moved the alias from the source query to the subquery so it's only looking at itself and not the encapsulating dataset.

I believe the right answer SHOULD be 4. Yes.

Can this work?

1. You will receive a syntax error - You don't receive a syntax error in SQL Server 2008 R2

2. No....

The request is a little unclear to me. Can you supply a sample of what you would expect from the resultset so we can understand further?

I'm not sure I understand. If I use

@From_Address = 'ErinRamsay<some@replyaddress.com>' both the name and reply address are overridden. Which Name field are you trying to change?

If the why isn't as important as the what in this case you could always use the

@From_Address =

You may want to use a full outer join rather than EXCEPT as you're only comparing in one direction.

Have a look at this article in order to use an effective hierarchical model in SQL Server.

http://msdn.microsoft.com/en-us/magazine/cc794278.aspx

I'll take a shot in the dark. You're setting the current date to last month. Try setting it to this month.

DATEADD(mm,0,getdate())

This link demonstrates how to use OPENDATASOURCE:

http://msdn.microsoft.com/en-us/library/ms179856.aspx

You'll probably need to exercise your GoogleFu to look up some of the information the OPENDATASOURCE requires.

As for SSIS, if you're using...

Couple of options I can think of off th bat.

1. Export your contact list to CSV file and import into your database.

2. Use the code at this location: http://support.microsoft.com/kb/170320 to...

If I remember correctly, DBMail is the service which actually sends the email but is NOT the service the queues them up to be sent so SQL Server will queue...

I don't suppose you have access to Integration Services?

Barring that, what about using an Excel file template and using [COde="sql"]INSERT INTO OPENDATASOURCE (.....[/CODE] to write your query into it? That...

Not sure if it will work as I haven't tried it but you define a text field in Excel by using the single quote. ie. 2459 when put in a...

Lol.. good point, Sean. I got side-tracked by a sendmail issue in my systems and posted before it was finished..