Hi gud evening,
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],....
Kindly change in this query
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]
how to pass @PFactor in dynamic query