It's the number of rows to skip over and should normally...

Try the following query:

[font="Courier New"]select   tr.policy_expiration_date_key,ex.cal_date

from  

           tr

      inner join

          ..datedim ex

         on ex.date_key = tr.policy_expiration_date_key

where transaction_audit_key = 178

AND (EX.Cal_Date < Cast('1900-01-01' as datetime) OR EX.Cal_Date > Cast('2079-01-01' as datetime))

order...

Post the trigger code.

Yes, delete them all in one SQL statement instead of deleting one row per statement.

Unlike Oracle, SQL triggers fire per statement, and not per-row.

This is a SQL 2005 forum. There are SQL 2000 forums on this site also.

OK, looking at your data now, it is clear that my routines do not respect the relationship between your "Order By" fields and the sequencing of CumInDemand. I do...

I think that you would need to write a stored procedure or a CLR to do it on their behalf. Very tricky to give them all of the abilities...

Jeff Moden (5/1/2008)

---

Michael Valentine Jones (5/1/2008)

---

Jeff Moden (5/1/2008)

---

Or "number" or "sequence" or... that's...

OK, well I am going away for the weekend and I don't have time to clean it up, so you'll have to take it as is...

Here is the Test-Rig (everything...

You can also get this information through the ANSI-standard INFORMATION_SCHEMA views provided by SQL Server. All of these are read-only, of course.

I have to agree with Jeff here. You *could* use DML triggers to achieve the same effect for data, but I really think that you would be buying yourself...

Jeff Moden (5/1/2008)

---

Just to throw another name into the mix, I've heard some people call what I'm calling a "Tally" table, an "Index" table, which also seems appropriate considering its...

Just google "tally table". The procedural (manual) form is used by schools a lot.

None of the TOP(XX) methods that I have been testing are able to keep up with the Row_Number() technique that I posted.

Jeff Moden (5/1/2008)

---

rbarryyoung (4/30/2008)

---

That's probabrly why, Jeff. I did some work for an insurance company several...