Both Points are well taken and in some cases I may want to run on an individual scout. There would be times where a scout may want to drop out...

ALZDBA ... Thank you this looks very clean. I have a few additional questions for you specific to your comments.

Remarks:

- double check your tables are indexed for their FK columns...

Yes you are correct. The primary point is: all scouts who have REF_SCT_RANK_ID = 5 must be updated as INACTIVE in the STATUS column. However Parent STATUS will be based...

The SQL statements were all created in Query Analyzer (Script Object to clipboard as - right mouse) which all should be compatible to 2000. I only own SQL 2000. As...

This really not an option since I am doing a bulk update. And because the status column has been used in so many procedures and other runtime components the rework...

Thanks, but what is your recomendation for removing the last comma after the last record returned. This what I do not know what to do. Thanks

So is there anyway to include the results from a SELECT Statement into the body of the e-mail to be sent out.

Cool I got it. Haven't done SQL in awhile

SELECT

A.TRAINING_NAME,

A.MANDATORY,

CASE

WHEN B.DATE_COMPLETED IS NULL THEN 'Not Completed'

...

Before I had time to repost I had this as well:

SELECT

*

FROM

[dbo].[TRAINING] A

LEFT OUTER JOIN [dbo].[xref_PG_TRAINING] B

ON A.[TRAINING_ID] = B.[TRAINING_ID]

AND B.PG_ID...

NO IDEA How to do this. Here is what I have so far and I know this is not right considering the where clause is only allowing me to see...

What it comes down to is that I want to display all Training Records from the TRAINING table, and but for those training classes that an individual has taken I...

Drew and Julie thank you for so many great examples.

Drew I did run your final post code and received the following error:

>[Error] Script lines: 1-14 -------------------------

Incorrect syntax near...

Sorry for the bad etiquette. I have included all the necessary SQL or creating tables and for inserting some data. Again the output should like the following:

Column 1 (Scouts Name),...

So what is the best way to:

1) Capture all Constraints including FK Constrints in SQL for every table in a DB and dropping them

2) Import new data

3) Re-Create all Constraints...