Nope, as long as a single field identifies a...

To use EXISTS you'd need to get craftier

select *

from testscores as ts1

where alpha_score_1 like 'f%'

and not exists (select * from testscores where alpha_score_1 like 'p%')

Becomes

select *

from testscores as...

Because you used EXISTS/NOT EXISTS instead of IN.

Books Online

---

When a subquery is introduced with the keyword EXISTS, it functions as an existence test. The WHERE clause of the outer query...

Yes... I took a wildswing as to what the field may or may not be called.

It's also why I asked for the structure. 🙂

The problem then is that your query is filtering record by record. Just because the table has multiple records for the same user and some have the p1,p2 doesn't...

Sample Data, Actual Structure please.

Are the f1,f2,f3,p1,etc values all in the field on a single record, or does each f1,f2,p1,p2 have it's own record?

Can you provide the table structure please?

Odds are your Primary Key is neither the State nor the County?

Sergiy (4/3/2008)

---

If you don't know something you must assume the worst.

And if...

Do you have the structures for the table(s), syntax of the queries, sample data, etc?

Hard to help with nothing to see.

Ok... after pushing up to 100K rows I see your point.

Is there a way to use DATEDIFF and get an Index Seek? I'm a little sad that my favorite...

Perhaps I screwed up my index here, but I get a table scan from each of these

create table datevalues (

dates datetime,

somevals integer )

create index bobsyouruncle on datevalues(dates DESC)

create statistics suesyouraunt...

Why not just use

WHERE

DATEDIFF(day,processdate,getdate()) = 1

??

Not 100% sure what you're asking here, but...

CREATE PROCEDURE IS_MGR

@STATUSFLG Bit

AS

IF (@STATUSFLG = 1)

BEGIN

(... Put Code Here...)

...

I don't have the structure of...

You can use whatever you like for the substitution character, but if you use something other than ? you need to specify it with a second parameter to the sp_msforeachdb...