CREATE/ALTER PROCEDURE' must be the first statement in a query batch
GO declare @sqlCmd varchar(max) select @sqlCmd = ' GO USE [CRM] ALTER PROC [dbo].[uspReportTrasnlationOpticalCabinetToNormal] ( @requestsId varchar(max) = null --@IsSuccess bit output ) AS BEGIN Set XACT_ABORT ON SET NOCOUNT ON BEGIN TRY --SELECT @IsSuccess = 0 SELECT R.ID RequestID, TC.ToTelephoneNo, TC.FromTelephoneNo, ISNULL(C.FirstNameOrTitle,'') FirstNameOrTitle, ISNULL(C.LastName,'') LastName, ISNULL(A.AddressContent,'') InstallAddress, ISNULL(A.PostalCode,'') InstallPostalCode, ISNULL(AA.AddressContent,'') CorrespondenceAddress, ISNULL(AA.PostalCode,'') CorrespondencePostalCode FROM Request R INNER JOIN TranslationOpticalCabinetToNormal TN ON TN.ID = R.ID INNER JOIN TranslationOpticalCabinetToNormalConncetions TC ON TN.ID = TC.RequestID LEFT JOIN [Address] A ON A.ID = TC.InstallAddressID LEFT JOIN [Address] AA ON AA.ID = TC.CorrespondenceAddressID LEFT JOIN Customer C ON C.ID = TC.CustomerID WHERE TN.[Type] = 2 AND (@requestsId IS NULL OR LEN(@requestsId) = 0 OR R.ID IN (SELECT * FROM DBO.ufnSplitList(@requestsId))) --SELECT @IsSuccess = 1 END TRY BEGIN CATCH EXEC [dbo].[uspLogError] --SELECT @IsSuccess = 0; THROW; END CATCH END ' EXECUTE (@sqlCmd) AT [mylinkedserver] GO
EXECUTE (N'USE [CRM]; EXEC sp_executesql N'''+@sqlCmd+'''') AT [mylinkedserver]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)