if there is a 1 in field1 i need to treat it as though its a null so i tried this but no luck. can you see what i am...

Sorry to bother you again. I need to check if the field1= '1' and replace it if it is .

this does but then it puts the 1 in the...

Thanks Very much for this i was trying to also get it to work using this method (it is easier to follow). but get an error like

Msg 1033, Level 15,...

yes thats correct. To be honest i havent gotten very far . I have never used coalesce update query.

are there any examples about?

Many thanks

I need to do at database level because i am using an open source code to create the data entry screens. So dont have access to the procedures

Do you know...

Please ignore this..I was trying to run it with windows server 2008.

I think its because all the access drivers were not installed.

Fair enough

let me see if i can translate to my the business process.

Just one thing...and i think i need to get my head around it...a few of the different events...

Your too Kind Graham

can you email me on frecal@internode.on.net

I will email you the info when i get it together

thanks again

Fred

Hi Graham

thanks for this. I will give them a go but just to try to explain to you the scenario.

basically a person has an event which can be different type....

yes that is unique and at the moment i store it in the main table then run an update routiine using it to retrieve the MLK. I thought it would...

Thanks Ian

i have been given more information to think about now.

seems like they all should not have the same Key to connect them

heeps of thinking to do

cheers

Fred

Hi John

I have tried to create a test scenario.

so basically i add the record to the main table so it generates the MLK.

I then would like to retrieve that...

Yes thats right..is that good practice you reckon?

If i have a business key i would add that to the main table and add that record then do a lookup...

thanks for the Help

I am using SSIS 2008 to import data into Sequel Server. Source are text files

Not sure if this is best method of doing this but the auto...

thanks for the response.

The sons will have different information to the fathers .

and the sons wont be a father.

I am leaning towards having 2 tables

a Father table and a...