title: SQL Server, View using multiple select statements
body: <p>I've banging my head for hours, it seems simple enough, but here goes:</p>
  
  <p>I'd like to create a view using multiple select statements that outputs a Single record-set
  Example:</p>
  
  <pre><code>CREATE VIEW dbo.TestDB
  AS
  SELECT     X AS 'First'
  FROM       The_Table
  WHERE     The_Value = 'y'
  
  SELECT     X AS 'Second'
  FROM       The_Table
  WHERE     The_Value = 'z'
  </code></pre>
  
  <p>i wanted to output the following recordset:</p>
  
  <pre><code>Column_1 | Column_2
  'First'    'Second'
  </code></pre>
  
  <p>any help would be greatly appreciated!
  -Thanks.</p>