Click here to Skip to main content
12,075,783 members (35,879 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL
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
Posted 29-Apr-13 3:00am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Hi ,
You will use sp_exexutesql for this.
exec sp_executesql @QueryString,N'@PFactor NUMERIC(18,2)'
,@PFactor
Check the following links
Advantage of sp_executesql over Exec[^]
SP_EXECUTESQL vs EXECUTE/EXEC[^]
sp_executesql (Transact-SQL)[^]

Regards,
GVPrabu
  Permalink  
v3
Comments
Maciej Los 29-Apr-13 10:50am
   
+5
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Try
SET @PFactor=(SELECT MonPfactor FROM dbo.CbzCurMst WITH(NOLOCK) WHERE CurType='INR'
  Permalink  
Comments
gvprabu 29-Apr-13 10:37am
   
he is asking about Dynamic Query...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100