Description |
Customer:
* Custer Grain (irely01)
* Central Ohio Farmers (irely01)
* Keller Grain (irely01)
* Chula Farms
* Webster and Garner
Company: irely01 (Please check also 02, 03, 99 and EM)
Current Build: 18.1.1218.521
DAtabase: \\fileserver\d$\PROJECTS\i21\Databases\Custer
Failed in upgrading database to 18.1.1228.534
Log:
Error SQL72014: .Net SqlClient Data Provider: Msg 195, Level 15, State 10, Procedure uspRKRiskPositionInquiryChart, Line 81 'FORMAT' is not a recognized built-in function name.
Error SQL72045: Script execution error. The executed script:
ALTER PROCEDURE [dbo].[uspRKRiskPositionInquiryChart]
@intCommodityId INT, @intCompanyLocationId INT, @intFutureMarketId INT, @intFutureMonthId INT, @intUOMId INT, @intDecimal INT, @intForecastWeeklyConsumption INT=NULL, @intForecastWeeklyConsumptionUOMId INT=NULL, @intBookId INT=NULL, @intSubBookId INT=NULL
AS
IF ISNULL(@intForecastWeeklyConsumptionUOMId, 0) = 0
BEGIN
SET @intForecastWeeklyConsumption = 1;
END
IF ISNULL(@intForecastWeeklyConsumptionUOMId, 0) = 0
BEGIN
SET @intForecastWeeklyConsumptionUOMId = @intUOMId;
END
DECLARE @strRiskView AS NVARCHAR (50);
SELECT @strRiskView = strRiskView
FROM tblRKCompanyPreference;
DECLARE @tblFinalDetail TABLE (
intRowNumberFinal INT DEFAULT 0,
intRowNumber INT ,
strGroup NVARCHAR (500) COLLATE Latin1_General_CI_AS,
Selection NVARCHAR (500) COLLATE Latin1_General_CI_AS,
PriceStatus NV
|