DuncEduardo (8/23/2016)

---

I wouldn't say it's completely a "running total" problem as you require only previous 12 records from the one in scope.

Running Total will keep adding next value but not...

JasonClark (8/23/2016)

---

Try to run the below code to prevent accidental delete:

CREATE TRIGGER [TR_ProtectCriticalTables]

ON DATABASE

FOR

DROP_TABLE

AS

DECLARE @eventData XML,

@uname NVARCHAR(50),

...

The second article is written in growlingly poor English. I read it this morning. Despite some relief - in the comments - from the frustrating language and the glaring omissions...

DuncEduardo (8/23/2016)

---

What's the quickest way to sum "last 12 months" values from one date column and update 2nd column?

e.g. original data contains "Date" and "Value", and we need to update...

Messi (8/23/2016)

---

ChrisM@Work (8/23/2016)

---

You have two rows in each table where Risk_01_Id_Num = '201600015'. Your result set with four rows is expected behaviour. If you wish to limit the result set...

Is there a clustered index on the table?

What proportion of rows...

SELECT RowId, AssetCode, WorkOrder, RequiredByDate, TimeDown, ReportText

FROM (

SELECT RowId, AssetCode, WorkOrder, RequiredByDate, TimeDown, ReportText,

rn = ROW_NUMBER() OVER(PARTITION BY AssetCode ORDER BY RowID)

FROM #TempTable

) d

WHERE rn = 1

ORDER BY...

You have two rows in each table where Risk_01_Id_Num = '201600015'. Your result set with four rows is expected behaviour. If you wish to limit the result set to two...

ashok.theagarajan (8/22/2016)

---

I have a main table where I need to map the Time part of Open Time (a date time field) with a shift table containing the shift timings.

Select...

kramaswamy (8/17/2016)

---

...Basically the difference between the two is that, in the former case, I'm filtering out the deleted records from TableA on the join with TableB at the same time...

drew.allen (8/19/2016)

---

ChrisM@Work (8/19/2016)

---

Why can't you use this, Phil (substituting "peanut" for an appropriate integer value):

UPDATE #test

SET Flag = @Flag

WHERE Id...

Or even this:

UPDATE #test

SET Flag = CASE

WHEN ISNULL(Flag,peanut) <> ISNULL(@Flag,peanut) THEN @Flag

ELSE Flag -- <-- NON-UPDATING UPDATE

END

WHERE Id...

Why can't you use this, Phil (substituting "peanut" for an appropriate integer value):

UPDATE #test

SET Flag = @Flag

WHERE Id = @Id

...

Not uncommon. Here's how someone who really knows what he's doing fixed the very same problem.

Steve Jones - SSC Editor (8/18/2016)

---

Luis Cazares (8/18/2016)

---

We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some...