It's not a duplicate. See, definition of duplicate.

DY-NO-MITE!!!!!!!!!!!

Thanks

The question presented was not "how should I label my columns?"

It's just an example. This data does not mirror the actual data but does mirror some of the issues. The actual tables is a list of different status...

You need to create that data.  Either create a trigger to capture the data you want to an audit table.  Or add a modified date column to the table and have...

I think I just figured this out.  This at least works with this small data set.

Select ProductName, #Example.PurchaseDate

FROM #Example

JOIN

(SELECT ProductID, Max(PurchaseDate) AS PurchaseDate

FROM #Example

GROUP BY   ProductID) AS Bob

ON #Example.PurchaseDate...

That's ok BH.  This place is filled with anal people.

Have you ever set up any jobs/maintenance plans?  The name will probably be in msdb under one of the sysjobs... tables.

check out

http://www.sqldev.net/xp/xpsmtp.htm

SQL Server doesn't use IF...THEN.  Just IF/ELSE IF.  However, THEN is used with CASE.

How come you don't want to do it the way you show in your example?  That is to set the value of the variable to whatever you want and then...

The trigger will fire regardless of the e-mail.  The trigger is not contained in "@query" for xp_sendmail.  In fact, @query is not used.  Granted you won't ever receive the information...

How does DTS know whether the comma is regular or a delimiter?

What if the data contains commas?

Here's an example you can try using Northwind.  Just build on it.

USE Northwind

GO

CREATE TRIGGER dbo.TableUpdateNotification

ON dbo.Employees

AFTER INSERT, UPDATE

AS

DECLARE @sql varchar(4000)

SELECT @SQL = LastName FROM Inserted

EXEC master.dbo.xp_sendmail

 @recipients =