Hi all,
I've been tasked with converting this Access update query to TSQL. I' not familiar with Access' "DISTINCTROW". Thanks.
UPDATE DISTINCTROW dbo_tblTransactions SET dbo_tblTransactions.curTotalAP = 150, dbo_tblTransactions.curTotalAR = 150, dbo_tblTransactions.curCarrierFSC = 40, dbo_tblTransactions.curCustomerFSC = 40, dbo_tblTransactions.intAlteredBy = 2106, dbo_tblTransactions.dteAlteredOn = Now()
WHERE (((dbo_tblTransactions.curCarrierFSC) Is Null Or (dbo_tblTransactions.curCarrierFSC)=0) AND ((dbo_tblTransactions.intMileage)>0) AND ((dbo_tblTransactions.intCustomer)=312172) AND ((dbo_tblTransactions.intCarrier)=623 Or (dbo_tblTransactions.intCarrier)=822) AND ((dbo_tblTransactions.dteFreightBillRecd) Is Null));