Viewing 15 posts - 5,506 through 5,520 (of 7,636 total)
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...
September 17, 2008 at 11:43 am
rbarryyoung (9/17/2008)
Greg Snidow (9/17/2008)
September 17, 2008 at 10:59 am
Arthur.Lorenzini (9/17/2008)
it actually holds SSN without the dashes....
September 17, 2008 at 10:52 am
Greg Snidow (9/17/2008)
September 17, 2008 at 10:50 am
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. ...
September 17, 2008 at 10:39 am
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...
September 17, 2008 at 8:46 am
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
...
September 17, 2008 at 8:33 am
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)')
...
September 17, 2008 at 8:23 am
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...
September 17, 2008 at 8:02 am
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...
September 17, 2008 at 7:57 am
Thanks for the feedback, me.
September 16, 2008 at 11:29 am
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...
September 16, 2008 at 10:11 am
Oh yeah, ... and do change to @Key instead of @@Key.
September 16, 2008 at 9:59 am
Viewing 15 posts - 5,506 through 5,520 (of 7,636 total)