Modified version works like a charm :-):-):-)

USE [NetPortal]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Create date: <2010/08/09>

-- Modify Date: <2016/01/27>

-- =============================================

ALTER FUNCTION [dbo].[NetPortal_GetProductPrice]

(

@ProductCodevarchar(24),

@RateStructure varchar(24),--MEMBER or LIST

@Subsystem varchar(10) = null

)

RETURNS numeric(12,2)

AS

begin

declare@CurrentPricenumeric(12,2)

set @CurrentPrice...

Thank You all, we changed the function how it was calculating the discount price for particular products in select statement

This is Old Function

USE [NetPortal]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

--...