Hi I used following t-SQL command to Update name in the TEST_DeliveryAddress table ,need to take CustAddTest Table name.
But no errors and showing successfully run the query but NOT updating the TEST_DeliveryAddress Table name field.Any idea what is wrong
Thanks
BEGIN TRY
BEGIN TRANSACTION
UPDATE
TEST_DeliveryAddress
SET
name = OT.name
FROM
CustAddTest T
INNER JOIN
TEST_DeliveryAddress OT
ON
T.[Customer] = OT. [Cust_Number] AND T.cust_seq=0
COMMIT
END TRY
BEGIN CATCH
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.