samplejoin, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

create table LASTSYNCEDREQUEST (id int, Loadid varchar(100),Shipmentid varchar(100), orderid varchar(100),packageid varchar(100), customerOTP varchar(100),clientOTP varchar(100))
insert into LASTSYNCEDREQUEST values
(1,
'L1',
NULL,
'234567',
'P456',
'44444',
'686868')

create table NEEDTOSYNCREQUESTS  (id int, Loadid varchar(100),Shipmentid varchar(100), orderid varchar(100),packageid varchar(100), customerOTP varchar(100),clientOTP varchar(100))
insert into NEEDTOSYNCREQUESTS  values
(1,
'L1',
'123',
NULL,
'P456',
'99999',
'88888')

select
    id      = N.id,
    Loadid  = case 
                when ISNULL(N.Loadid,'')=ISNULL(L.Loadid,'') 
                then NULL
                else N.LoadId
              end,
    Shipmentid=case 
                when ISNULL(N.Shipmentid,'')=ISNULL(L.Shipmentid,'') 
                then NULL
                else N.Shipmentid
              end,
    orderid=case 
                when ISNULL(N.orderid,'')=ISNULL(L.orderid,'') 
                then NULL
                else N.orderid
              end,
    packageid=case 
                when ISNULL(N.packageid,'')=ISNULL(L.packageid,'') 
                then NULL
                else N.packageid
              end,
    customerOTP=case 
                when ISNULL(N.customerOTP,'')=ISNULL(L.customerOTP,'') 
                then NULL
                else N.customerOTP
              end,
    clientOTP=case 
                when ISNULL(N.clientOTP,'')=ISNULL(L.clientOTP,'') 
                then NULL
                else N.clientOTP
              end
from
NEEDTOSYNCREQUESTS N LEFT JOIN
LASTSYNCEDREQUEST L ON
N.id=L.id

View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 2, absolute service time: 0,17 sec