Here's an option :

UPDATE tblMemberContact

SET tblMemberContact.Board = 1

WHERE tblMemberContact.ContactId in (

SELECT dbo.tblContact.ContactID

FROM dbo.tblMemberContact INNER JOIN

dbo.tblContact ON

...

HTH.

Datefield is the value that you base your calculations on. I was under the impression that this also was a column in the table.

Here's #2000

Nice touch... didn't know that function .

In the lights of this new knowledge, I would definitly go with that option... Still assuming...

I was rereading your post and didn't see any difference... Was wondering if I were going blind all of a sudden.

Anyways, I think I would use Count(*) if case permits......

select count(doc_iccmc) cnt,doc_iccmc from v_DOCUMENTDIRECTORY

group by doc_iccmc

Having count(doc_iccmc) > 2

Try this in text result mode :

SET SHOWPLAN_TEXT ON

GO

DECLARE @Temp TABLE

(RowId int NOT NULL IDENTITY(1, 1),

Col1 varchar(20) NULL,

PRIMARY KEY CLUSTERED (RowId) )

Select * from @Temp where RowId = 1

Select...

How can it be the same person if they don't have the same last name??

Anyways, here's more info on the soundex. It looks like it stops analysing at the...

Still not sure of what you want...

Update tblMemberContact set Board = 1 /*true*/ where Contact_ID = 20

This will update all the rows of the table with a contact_id of 20....

Cool, post again if you need further assistance.

You just have to know where to look for this kind of stuff .

No thanx... I don't drink.

if object_id('Tempdb..#temp') > 0

DROP TABLE #temp

GO

Create table #temp

(

id int not null identity (1,1) primary key clustered,

SSN CHAR(9) not null

)

GO

Insert into #temp (ssn) values ('123456789')

Insert into #temp (ssn) values ('987654321')

Insert into...

Well you can create a temp table with identity instead of the current id column, set identity_insert on for that table, ship all your current data to this table,...

update the whole table for the field id = 20 or the field id = 20 and is in this query?