<div>
you cannot SELECT at SET in the same statement.
</div>


you cannot SELECT at SET in the same statement.

<div>
anyhow, do you really need the @p?<br />

<pre><code id="code-131677">SELECT
      P2.PartNo, P2.GroupingCode, P2.Code, P2.Qty,
 
      CASE WHEN P2.Qty &gt; 10 
           THEN  10000 
           ELSE  -99 
      END AS VarValue
FROM
      tblPickingList P2</code></pre>
</div>


anyhow, do you really need the @p?


SELECT
      P2.PartNo, P2.GroupingCode, P2.Code, P2.Qty,
 
      CASE WHEN P2.Qty > 10 
           THEN  10000 
           ELSE  -99 
      END AS VarValue
FROM
      tblPickingList P2

<div>
Yes, I just use it in that simple example for explanation purposes.<br />
Where I will be using it it could ease my life a lot. :)
</div>


Yes, I just use it in that simple example for explanation purposes.
Where I will be using it it could ease my life a lot. :)

<div>
What do you mean with &quot;just a single value&quot; ?<br />
<br />
Thanks for quick replies. <br />
:)
</div>


What do you mean with "just a single value" ?

Thanks for quick replies.
:)

<div>
as I wrote: just 1 single value.<br />
<br />
you did not really explain what you actually try to achieve, so I can only give &quot;guessings&quot; ...
</div>


as I wrote: just 1 single value.

you did not really explain what you actually try to achieve, so I can only give "guessings" ...

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Is it possible to assign different values to a parameter in a SQL statement based on your select field's value.<br />
<br />
Please see code snipped for a clearer understanding.<br />

<pre><code id="code-131676">DECLARE @P INT 
SELECT
	P2.PartNo, P2.GroupingCode, P2.Code, P2.Qty, 
	CASE WHEN P2.Qty &gt; 10 THEN 
		SET @P = 10000 
	ELSE 
		SET @P = -99 
	END,
        @P AS VarValue
FROM
	tblPickingList P2
</code></pre>
</div>
</div>


Dear Experts,

Is it possible to assign different values to a parameter in a SQL statement based on your select field's value.

Please see code snipped for a clearer understanding.

MS SQL 2005 :: SET Variable Value Dynamically Based On Select Field's Value

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.