I am not sure about the rest, but you should understand that a FULL JOIN is NOT the same thing as a Cartesian Join.

"FULL JOIN" is an abbreviation for "FULL...

rbarryyoung (9/17/2008)

---

Greg Snidow (9/17/2008)

---

Barry, what is the significance of the numbers in the IN group? If the ids are random, then couldn't the possibilies be endless? In light...

... CONVERT() works as well. 🙂

Arthur.Lorenzini (9/17/2008)

---

I think that will work except for a small issue with a conversion. In my actual table, the ID column is a CHAR(9)

it actually holds SSN without the dashes....

Greg Snidow (9/17/2008)

---

Barry, what is the significance of the numbers in the IN group? If the ids are random, then couldn't the possibilies be endless? In light of...

Actually, with SMTP, I they can both be telling the truth, especially if you have relay servers or an external Exchange host provider.

SMTP is not a guaranteed delivery protocol/service. ...

I suspect that the reason that your original script was failing is this line:

@query = 'set nocount on select * from ##temp_table',

I do not think that the...

Frankly, this sounds more like an SMTP issue.

While I really think that you need to clarify your definition a little better Arthur, here is a hack at it, using a modification of Greg's code:

SELECT

...

Here's a simple example to get you started:

CREATE TRIGGER sProc_Trigger

ON DATABASE

FOR CREATE_PROCEDURE

AS

PRINT 'CREATE PROCEDURE Issued.'

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

...

If you do not have the Order totals ahead of time, then you can do something like this:

WITH cteOrders As

(Select SUM(Detail_Cost) as Order_Total

From OrderDetail

Group By OrderID)

SELECT

SUM(Case

When Order_Total...

You only need a CTE if you do not already have the Order Totals. If you do, then this is all you need:

SELECT

SUM(Case

When Order_Total > 300.00 Then...

Thanks for the feedback, me.

Agreed Jack. Generally, you only want to use triggers when there is no other reasonable and reliable way to do something. If polling is workable for you, then...

Oh yeah, ... and do change to @Key instead of @@Key.