Ahh! typical. Sorry I couldn't be of more help.

As you say SQL is SQL (maybe!). 🙂

Ah, not SQL Server then. Your best bet then is the elevate software website.

Don't see why that wouldn't give you all records from both tables, that's exactly what 'UNION ALL' does.

What makes you think is not returning all records ?

Can you do a...

Thanks for the feedback, glad to be of help.

Based on the limited information you have provided you need to look up the JOIN statement in BOL here, or Google it here

Larry,

Going to need a lot more information here, see the 'How to post...' link in my sig below for some help.

It would have helped if you had provided more information, such as table definitions some test data etc., please see the link in my sig below.

Anyway what about this?:

DECLARE @t...

UPDATE

MyHomework

SET

Answer = 'Correct'

WHERE

MyEffort IS NULL

Sorry, I just replied! :blush:

Not encountered Lennie before

o!

You are creating a big security hole in your application here. As Lynn mentioned you should *not* build up SQL in the application like this you should use a stored...

Be aware that this only works if DATEFIRST is 7. You'll need to adjust the calculation accordingly.

It is good practice to use an appropriate type to represent a date, ie DATETIME or DATE (in 2008), rather than split it into it's component parts.

In your case when...

...and you are assuming your database language is english

One thing, the sp_send_dbmail proc is in the msdb database your code should look like this:

EXEC msdb.dbo.sp_send_dbmail ...