Database

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(destination_table.title) =

UPDATE customers destination_table

SET (destination_table.title) =
(

   SELECT source_table.title

   FROM customers source_table

   WHERE source_table.customer_id = 18

)

WHERE destination_table.customer_id = 14;

ALTER PROCEDURE [dbo].[spVendorUpdateVendor] 
-- Add the parameters for the stored procedure here
                                @VENDORID          INT,
                                @ACTIVE            BIT,
                                @COUNTRYID         INT,
                                @VENDORCODE        NVARCHAR(10),
                                @NAME              NVARCHAR(50),
                                @WEBSITE1          NVARCHAR(50),
                                @WEBSITE2          NVARCHAR(50),
                                @VIACODE           NVARCHAR(10),
                                @TERMS             SMALLINT,
                                @USECOMPCODE       BIT,
                                @DISCOUNTPERCENT   SMALLINT,
                                @DELETEDBYID       INT,     -- Pass 0 if not deleting the record
                                @DELETEDON         DATETIME,
                                @NONUS             BIT,
                                @NOTES             NVARCHAR(MAX)

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
	BEGIN TRY
                                
        	IF EXISTS(SELECT ID FROM VENDOR_MASTER WHERE ID = @VENDORID)
                	BEGIN                                                  --<< SQL SERVER SAYS THE ERROR IS ON THIS LINE

			        IF (@DELETEDBYID > 0) AND (NOT EXISTS(SELECT USERID FROM USERS WHERE USERID = @DELETEDBYID))
                                	BEGIN
                                        	RETURN 2; -- DeletedById does not exist in USERS table
                                        END

                                IF (NOT EXISTS(SELECT * FROM COUNTRY_CODES CC WHERE CC.COUNTRYCODE = @COUNTRYID))
                                	BEGIN
                                        	RETURN 3; -- Country Code does not exist in COUNTRY_CODES table
                                        END

                                IF (NOT EXISTS(SELECT SHIPVIACODE FROM ORDER_HANDLE_MASTER_SHIPVIA_CODES WHERE SHIPVIACODE = @VIACODE))
                                        BEGIN
                                                RETURN 4; -- VIA CODE does not exist.
                                        END

                                UPDATE VENDOR_MASTER SET	ACTIVE          = @ACTIVE,
								COUNTRYID       = @COUNTRYID,
								VENDORCODE      = @VENDORCODE,
   								NAME            = @NAME,
								WEBSITE1        = @WEBSITE1,
								WEBSITE2        = @WEBSITE2,
								VIACODE         = @VIACODE,
								TERMS           = @TERMS,
								USECOMPCODE     = @USECOMPCODE,
								DISCOUNTPERCENT = @DISCOUNTPERCENT,
								DELETEDBYID     = @DELETEDBYID,
								DELETEDON       = @DELETEDON,
								NONUS           = @NONUS,
								NOTES           = @NOTES

                                WHERE ID = @VENDORID;
			END
		ELSE -- IF EXISTS VENDORID
                	BEGIN
                        	RETURN 1; -- VendorId does not exist in Vendor Master table
                        END
	END TRY

        BEGIN CATCH
        	SELECT  ERROR_NUMBER()		[ErrorNumber],
                        ERROR_PROCEDURE()   	[ErrorProcedure],
                        ERROR_LINE()            [ErrorLine],
                        ERROR_MESSAGE()         [ErrorMessage]

                RETURN ERROR_NUMBER();
 	END CATCH

	RETURN 0;
END