Forum Discussion

skilly2000's avatar
skilly2000
Copper Contributor
Jul 11, 2022

Compare records in two tables

Hi

 

I would like to write procedure to compare Record (Col D - INT value) in Table A and compare with Record in Table B (Col G - INT value).  if records match then i would like to update the Record in Table A (Col L) with int value 

 

Not sure if its best to write Stored Procedure or Function?

 

TIA

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    That's to less on information.
    Please post table design as DDL, some sample data as DML statement and the expected result.

    Olaf

Resources