First of all I'd use a look up table for the status info (assuming you could have a 3rd or 4th status eventually), or simply a bit/tinyint column instead of...

Frank, now I understand why you have so many posts... You can't not get the last word. At this pace you'll be at 5000 posts this afternoon.

Hehe... it's not over you we're arguing and as far as I know Frank is married with children (new born included).

Have you tested my query on a large table... I...

not in (Select 1000 rows from ...) then check if the id is in there

not exists (Select 1 row and exit task as soon as the match is found) returns...

Price = 0 or Price 0 AND Status = 'For Sale'

Obviously, but I look better that way .

Have you tried running my statemement on the 8M rows table?.. I was wondering how long it would take to run it (if it doesn't interferre with production).

and to complete :

ALTER TABLE matsTable

ALTER COLUMN field1 CHAR(9) not null

Here's something that might help you :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=16197

check the 2nd post of ckempste

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=13768

Yes but this time I was replying to myself as new ideas came to me. And it wasn't pointless chatting like this .

I finally had the opportunity to check my theory.

1 - it doesn't work, as you ALWAYS move the searched item in the top 90% group which yields false results.

2 -...

Put all the columns that you need to transfer in the insert and select list omitting the primary key.

Insert into ArchiveTable (Col1, Col2, ColN)

Select Col1, Col2, Coln From dbo.Events...

Have you actually tried my solution???????

You can search for students that are suscribed in any number of course without modifying the proc. What else do you need?

Select Student from dbo.TableX where Subject IN ('German','Spanish')

GROUP BY Student

HAVING COUNT(*) = 2

I have never tested all the proposed solution for best performances. But the neat thing about this...

select Distinct 'Welcome to our member ' +[first name]+ '. Everyone say hello.' from names where [first name] is not null