Thanks for that, i'll have a read. In answer to your questions

Is there a foreign key between the 2 tables? there is no foreign key

Is it possible for a record...

Thanks for the reply. I need to delete the associated record in the wce_linkto table too. For every row in the wce_history table there is a linked row in wce_linkto...

That's great. i was playign with the select to get the update but that's going to save me loads of time. Thats for the help.

That's got it. Thanks very much for the help. I'll be keeping that script close to hand 🙂 Thanks again.

Hi Dan,

I think I am a little confused. Currently in your example all the records have the same client id. based on your example you what the learners client ID...

I just figured it with some help.

This is what i needed

Update q

Set q.client_id = c.client_id

From wce_contact c

...

Thanks for the help. Becuase i was using VBScript i managed to do something in that and got the result i needed.

I know this is a SQL forum and...

Hi,

I thave added both but when i print them to screen before they are inserted i get the following with no dates. It's just writting the code. Any ideas?

INSERT INTO...

Thanks for your reply. I need it like this 13/01/2010 10:00:00

I tried adding your code but i am am getting a syntax error at the begining of the -->SELECT dateadd(m,...

Thank you for that, just what i needed. I will read up on it but i can see the logic! Thanks again.

If i use this it returns no results, is that what you mean?

with cteEmployers( EDRS, Employer_Name, Emp_Phone, Emp_Address_1, Emp_Address_2, Emp_Address_3, Emp_Address_4, Emp_Address_Pcode1, Emp_Address_Pcode2, rown) as(Select wce_ilr.EDRS, wce_ilr.Employer_Name, ...

I think you can only get SQL Express which is the same thing but with a few limitations on how much data you can store (4 gig limit, more than...

Thanks that worked! However with this query working raises another question to an issue I have. Not sure if I should put up a new post for this or not...

Thanks for that. I altered my code to this and it looks like i'm getting the results i want. It de-duplicates and only displays the rows that do not exsist...

Any chance that someone can take a look at this and point me in the right direction?

Thanks