Hi Jeff

that would be the correct way of recording it but probably over kill for what i am needing it for.

I am working on a data linkage project and just...

I am using it as one to many ..one parent can have multipe relationships.

the query only really will indicate that the record has a relationship with another record in the...

Fantastic, will have a go with my real data tomorrow

thanks again

Fred

Hi

were you able to work this out?

I need to do something similar

thanks

Fred

I am using sql 2008...is this easy to do..are there any examples i can work with?

thanks

Fred

thanks for the reply.

can you explain why it would be advantageous to relate each record to itself.

I am not really sure what you mean

thanks

Fred

thanks for the reply

which account do you suggest it should be changed to. I would of thought that when i would of changed my windows password it would update the...

Hello, do you have an example which looks at a field in a table and converts all the records to Proper Case.

thanks

Fred

Hi Brian

what did you mean by >Can you script them out? I know it is error prone such as Mary Anne is Anne the middle ... Then once you script...

I think thats where my problem is..as you said if Mary Jane is in one firstname field and the comparing Firstname has Only Mary. it doesnt seem to match it....

Hi Brian

thanks for your help with this..I have a querie i am trying to work out not sure if you have come across an issue like this.

I am comparing...

excellent idea thanks.

was wondering how it compares when the dates are slightly different. i guess as you said as long as we have other variables like firstname, surname and gender...

thanks for your reply. why is that Date fields will only display for exact matches?

I cant set it to fuzzy matching.

the fields i use are firstname, surname, sex and Date...

Hi not sure if you will get this post or not but here goes.

I have started working on a Linkage Project and was mucking around with the Fuzzy Matching in...