DECLARE @PFactor NUMERIC SELECT @PFactor=MonPfactor FROM dbo.CbzCurMst WITH(NOLOCK) WHERE CurType='INR'
SELECT Vw.PrdVarCode AS [SKU], (SELECT CASE WHEN Sale=0 THEN Price*@PFactor ELSE Sale*@PFactor END ) AS [Price],....
DECLARE @PFactor NUMERIC SELECT @PFactor=MonPfactor FROM CbzCurMst WHERE CurType=''INR'' SELECT Vw.PrdVarCode AS [SKU], (SELECT CASE WHEN Sale =0 THEN Price * @PFactor ELSE Sale*@PFactor END ) AS [Price]
exec sp_executesql @QueryString,N'@PFactor NUMERIC(18,2)' ,@PFactor
SET @PFactor=(SELECT MonPfactor FROM dbo.CbzCurMst WITH(NOLOCK) WHERE CurType='INR'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)