title: How should I get the dummy columns using the Query in SQL Server (like 'select name from dual' in Oracle)?
body: <p>I am using SQL Server Reporting Services 2008 R2.
  I have designed a report which takes StartDate, EndDate, PayType as parameter values to run the report (dataset1).
  These parameter values are passed from another data set query.
  so I have written other query as (dataset2),</p>
  
  <pre><code>SELECT DISTINCT 
  bb_propdt AS [Start Date],
  bb_propdt AS [End Date],
  
  CASE 
  WHEN bbprop.bb_paytype = '1' THEN 'PDC' 
  WHEN bbprop.bb_paytype = '2' THEN 'NoPDC' 
  WHEN bbprop.bb_paytype = '3' THEN 'ECS' 
  ELSE 'NA'
  END AS [Pay Type] 
  
  FROM         
  bbprop
  </code></pre>
  
  <p>The problem is that, it is showing me all distinct dates, so far good.
  But it is also showing me distinct pay type.
  so in a parameter dropdown list I am getting number of PDC, NoPDC, ECS.
  What I want is only 3 values, PDC, NoPDC, ECS.
  I can use use another data set to solve this problem, but I don't want one more data set.
  I was searching like </p>
  
  <pre><code>select PDC, NoPDC, ECS from dual;
  </code></pre>
  
  <p>In SQL Server. But there is no such thing.</p>
  
  <p>Below pic will help you to get the problem easily. </p>
  
  <p><img src="https://i.stack.imgur.com/9NvY9.png" alt="enter image description here"></p>
  
  <p>This is showing me no. of dates, it is OK.</p>
  
  <p><img src="https://i.stack.imgur.com/lWVY6.png" alt="enter image description here"></p>
  
  <p>But here I want only three values as PDC, NoPDC, ECS.</p>