http://www.microsoft.com/sql/msde/downloads/default.asp

Let me put it this way... I have 3000+ hours experience with sql/sqlserver and I'm just starting to feel comfortable.

This is not something you can learn by yourself... You need...

Sorry, should have asked this earlier.

This is something that you do NOT keep in the db since it can be calculated easyly.

Select Production, dateadd(m, -6, Production) as Before, dateadd(m, +6,...

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.