That code does not contain a subquery, therefore the error message refers to something else.

UPDATE

SET sent = 1

WHERE sent IS NULL

AND Received(?) < DATEADD(HOUR, -2, GETDATE())

Actually, I thought it was pretty clear that as much as possible should be in the DB. Those business rules that cannot be implemented as DRI should be coded into...

There's 2 questions that come up with the DRI discussion:

1) Wthout DRI, is there a guarantee that the data has integrity? How? (This is not to say DRI can enforce...

How are you storing it? INT or VARCHAR?

If you're storing INT, then do nothing: it's a presentation issue, and you can format it on retrieval. (This is what we've done...

Automate any repetitive manual tasks, prioritized by the amount of time you spend doing them.

Write general-case and/or parameterized solutions for these, so that they will be ready to handle new...

Non-clustered index seek on SQL 2000 sp2. The table does not have a clustered index.

P

I tried LIKE and PATINDEX on a table with a unique constraint. When searching at the beginning of the string ('C%'), both used that index, with PATINDEX using INDEX SCAN...

Use LIKE when comparing from the beginning of a string.

Otherwise, LIKE and PATINDEX will usually have the same execution plan.

P

Actually, LIKE 'something%' will perform better (only when you're looking from the beginning of the string - LIKE '%something%' will do a table scan).

This is because LIKE can use an...

The parm is to limit the cursor rows?

DECLARE mycursor CURSOR FOR

SELECT cols

FROM mytable

WHERE col1 = @myparm

OPEN mycursor.....

Yep. Choose All Objects and Data, and you're on your way.

P

See CREATE FUNCTION in BOL...a table-valued function can only accept a constant or a variable in it's arguments.

No worries.

Thanks for clearing that up, Steve.

P