| Description |
See attached file for the error.
Ex:
Altering [dbo].[uspRKReconciliationBrokerStatementImport]...
(17384,1): SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspRKReconciliationBrokerStatementImport, Line 147 Invalid column name 'importId'.
(17238,0): SQL72045: Script execution error. The executed script:
ALTER PROCEDURE uspRKReconciliationBrokerStatementImport
@dtmFilledDate DATETIME, @intFutureMarketId INT, @intCommodityId INT, @intBrokerId INT, @intBorkerageAccountId INT=NULL, @intReconciliationBrokerStatementHeaderIdOut INT OUTPUT, @strStatus NVARCHAR (50) OUTPUT
AS
BEGIN TRY
DECLARE @strDateTimeFormat AS NVARCHAR (50);
DECLARE @ConvertYear AS INT;
DECLARE @ErrMsg AS NVARCHAR (MAX);
DECLARE @strFutMarketName AS NVARCHAR (50);
DECLARE @strCommodityCode AS NVARCHAR (50);
DECLARE @strName AS NVARCHAR (50);
DECLARE @strAccountNumber AS NVARCHAR (50);
SELECT @strFutMarketName = strFutMarketName
FROM tblRKFutureMarket
WHERE intFutureMarketId = @intFutureMarketId;
SELECT @strCommodityCode = strCommodityCode
FROM tblICCommodity
WHERE intCommodityId = @intCommodityId;
SELECT @strName = strName
FROM tblEMEntity
WHERE intEntityId = @intBrokerId;
SELECT @strAccountNumber = strAccountNumber
FROM tblRKBrokerageAccount
(17384,1): SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspRKReconciliationBrokerStatementImport, Line 147 Invalid column name 'importId'.
(17238,0): SQL72045: Script execution error. The executed script:
ALTER PROCEDURE uspRKReconciliationBrokerStatementImport
@dtmFilledDate DATETIME, @intFutureMarketId INT, @intCommodityId INT, @intBrokerId INT, @intBorkerageAccountId INT=NULL, @intReconciliationBrokerStatementHeaderIdOut INT OUTPUT, @strStatus NVARCHAR (50) OUTPUT
|