Using MSSQL 2000. I have a table with duplicate rows that needs to be updated. I have new values with similar table.
Need to update values of Table A using Table B. I see people on internet using CTE but it's not clear to me as I am new to SQL.
Table B may or may not have same number of rows as Table A, if it has less number of values, I can leave the original value as it is and if it has more values then I can skip extra values.