One approach is to populate an auxiliary table using an "after insert" trigger, and then have a job that processes the auxiliary table (and depopulates it) at whatever frequency is...

Good question. Not sure how I managed to get it wrong, because it's prety straightforward.

I guess it depends what it's a photo of. ...

Hugo Kornelis (12/10/2010)

---

(plus, that one is extremely unlikely, as the database for temporary object is called tempdb, not TempDB - but I guess only people who are in the...

Good question with clear answer options, but as several have pointed out the explanation is not a real explanation.

Yes, it changes now an...

You can have up to 16 key columns in a clustered index, but...

Celko's been at it again, and Gus's response http://www.sqlservercentral.com/Forums/FindPost1032150.aspx is unfair to monkeys.

Dimitrije Mišic (12/9/2010)

---

Hi, I'm making a procedure which parses Excel worksheet and uses that data to update db.

I've run into the problem with date field it is contingent on a...

Something like this should work provided you are using SQL 2005 or later.

;WITH RelevantData as (

SELECT D.LogTime, D.PID, D.Value, P.AggregationType

FROM tblData D...

Pedrsonally I hate triggers, and avoid them where possible. For audit it is not possible, triggers are essential - how can I have reliable audit data using some method...

Drat. I shall change to an older picture. 134 is a silly age to look.

Geoff, this comment should have come first, but I decided to read through all existing comments first and could resist responding to a couple of them. So please accept...

Brandie Tarvin (12/2/2010)

---

Often enough that I save all my procs so I...

I've spent most of my life in Britain and have never seen d used like that;...