Description |
Updating database (Failed)
09:30:04 PM - *** Could not deploy package.
09:30:04 PM - Error SQL72014: .Net SqlClient Data Provider: Msg 195, Level 15, State 10, Procedure uspCTReportContractDetailGrain, Line 65 'FORMAT' is not a recognized built-in function name.
09:30:04 PM - Error SQL72045: Script execution error. The executed script:
09:30:04 PM - CREATE PROCEDURE uspCTReportContractDetailGrain
09:30:04 PM - @intContractHeaderId INT
09:30:04 PM - AS
09:30:04 PM - BEGIN TRY
09:30:04 PM - DECLARE @ErrMsg AS NVARCHAR (MAX);
09:30:04 PM - DECLARE @intContractDetailId AS INT;
09:30:04 PM - DECLARE @ContractDetailGrain AS TABLE (
09:30:04 PM - intContractDetailGrainKey INT IDENTITY (1, 1),
09:30:04 PM - strItemNo NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - dblDetailQuantity NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - dblPrice NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - dtmStartDate DATE ,
09:30:04 PM - dtmEndDate DATE ,
09:30:04 PM - strPricingType NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - strShipVia NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - strLocationName NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
09:30:04 PM - intContractHeaderId INT ,
09:30:04 PM - intContractDetailId INT ,
09:30:04 PM - lblRemark
FINISH RUNNING SCRIPTS FOR 1830OriginBaseSQL2008R2
|