title: sql server joining two set of data
body: <p>I have the following simple (i think) requirement:</p>
  
  <p>Have one value lets say '1', then I have a table with one column which has more than one row.</p>
  
  <p>What is the SQL required so that I return two columns, the first column having all values of '1', the second column being the values from the table.</p>
  
  <p>Thanks,
  Bruce</p>