Description |
error 17-Nov-2015 19:31:29 Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspMFReportItemPlan, Line 963 Invalid column name 'strWorkOrderNo'.
error 17-Nov-2015 19:31:29 Error SQL72045: Script execution error. The executed script:
error 17-Nov-2015 19:31:29 CREATE PROCEDURE uspMFReportItemPlan
error 17-Nov-2015 19:31:29 @xmlParam NVARCHAR (MAX)=NULL
error 17-Nov-2015 19:31:29 AS
error 17-Nov-2015 19:31:29 BEGIN
error 17-Nov-2015 19:31:29 DECLARE @ErrMsg AS NVARCHAR (MAX);
error 17-Nov-2015 19:31:29 DECLARE @xmlDocumentId AS INT, @intNoOfDays AS INT, @strNoOfDays AS NVARCHAR (50), @strShowOpenWorkOrder AS NVARCHAR (50), @strShowFrozenWorkOrder AS NVARCHAR (50), @strShowPausedWorkOrder AS NVARCHAR (50), @strShowReleasedWorkOrder AS NVARCHAR (50), @strShowStartedWorkOrder AS NVARCHAR (50), @strItemNo AS NVARCHAR (50), @strCompanyLocationName AS NVARCHAR (50), @strItemGroupName AS NVARCHAR (50), @strShowStorage AS NVARCHAR (50);
error 17-Nov-2015 19:31:29 IF LTRIM(RTRIM(@xmlParam)) = ''
error 17-Nov-2015 19:31:29 SET @xmlParam = NULL;
error 17-Nov-2015 19:31:29 DECLARE @temp_xml_table TABLE (
error 17-Nov-2015 19:31:29 [fieldname] NVARCHAR (50),
error 17-Nov-2015 19:31:29 condition NVARCHAR (20),
error 17-Nov-2015 19:31:29 [from] NVARCHAR (50),
error 17-Nov-2015 19:31:29 [to] NVARCHAR (50),
error 17-Nov-2015 19:31:29 [join] NVARCHAR (10),
|