If just one field needs to be checked, then by all means - add that one thing into the WHERE. You still have to set up the update with...

Stephen Morley (6/12/2008)

---

The First() function in MSAccess returns the first record entered into the table.

SELECT TOP 1 is not the equivalent.

Try creating a new table in MSAccess with one...

Shouldn't the count of CASE be the numerator?

As in -

SELECT

COUNT(CASE WHEN DateCol > @DateEdge THEN 1 ELSE NULL END) --...

You spying on me again? with the various fun lately I am running rather ragged. I'm...

It's actually...

Jeff Moden (6/12/2008)

---

Jeff Moden (6/12/2008)

---

I think your @firstSunday should be a 7, no? Right now, you code lists Saturdays... of course that also means your code will (should) work...

well - you're setting up a scenario to bring back items whose name have a specific keyword (or several), which is essentially one of the things FTI does. It...

Lynn Pettis (6/12/2008)

---

Matt Miller (6/12/2008)

---

Makes me wonder if it wouldn't be easier to just to the select...INTO on stuff you want to keep, blow out the original table and reinsert...

Makes me wonder if it wouldn't be easier to just to the select...INTO on stuff you want to keep, blow out the original table and reinsert the items to keep.....

I...

Because of the leading wildcard in your LIKE statement - the optimizer essentially can't use your indexes efficiently, so I think you'll find that it's scanning the entire table (or...

hehe - It looks to me that the programmer in charge of date handling for excel was asleep at the wheel. Two things are causing your issue:

1. 0 doesn't...

You're essentially intercepting ALL updates, and not allowing them to happen. Per BOL:

In contrast with the AFTER trigger, the INSTEAD OF trigger fires before constraint processing and replaces the...

I had to go look it up again. I kind of remembered a way - but couldn't place what it was I needed.

Thanks for the heads up on 2008.

Oh - it absolutely is. Setting up drop-downs...

you can simply turn on scripting the trigger in scripting options. Once you do that, ask it to script a CREATE on the relevant table, and you should have...