i want to update table b which has two columns called id and code

from table a which has one column called id

table a has values like A10,A20 and so on

now...

i want to write an update and not an insert statement so how do i do that?

thanks for the help

Censored by the editor: This post was inappropriate and offensive to others who have posted in this thread.

JOIN has to be ON policynumber AS IT EXISTS IN ALL THREE TABLES and not on product type because product type exists only in GE_Transaction.

STILL I GET THIS ERROR MESSAGE

Server:...

NOTE :

Policy Number,  tablecode  are the two columns which exists in all the three TABLES

Thanks for the help to all of you

update the data

Can you write the actual query to show me becz i am still not cleared fully.

Thanks

i know how to use it but i dont know how to use it in this case

can you guide me please

it is datetime and i dont understand how to experiment with the DATEPART function .can you show me how to do it.

thanks

to give you a better understanding here is my script in which i want to implement cursor .The script in bold is where i want to apply cursor approach

drop...

when i run like this it also give me the same records

SELECT PolicyNumber, COUNT(*) AS Total FROM GE_ReservesFile GROUP BY PolicyNumber HAVING COUNT(*) > 1

yes it does give me counts equal to  141

i get the message 0 rows effected when i run this query

Select T.PolicyNumber from GE_ReservesFile G

right join #temp T on G.PolicyNumber = T.PolicyNumber

where G.PolicyNumber IS NULL

--OR This

Select PolicyNumber from #temp where...