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

I tried the code in a stored proc and it returned the error as expected without any furter message. The problem comes when you try to return a value...

Now I understand why you have so many posts Frank... You type 2-3 responses when none or 1 could do .

You could always do something like this :

Select 'This is a tables "' + name + '" / id = ' + cast(id as varchar(10)) from dbo.SysObjects where XType...