title: Select column with values greater 0
body: <p>I have an item database with 8 tables. There I wanted to write a stored procedure to select all values greater 0 for a specified item ID.
  My problem now is the statement to return only the columns where the value of the specified item is greater 0.</p>
  
  <p>Basically I write a simple select which returns the following data:</p>
  
  <p><a href="http://i.imagebanana.com/img/rhw2sm9u/1327501679.jpg" rel="nofollow noreferrer">Example 1 http://i.imagebanana.com/img/rhw2sm9u/1327501679.jpg</a></p>
  
  <p>When the Column "Cold" contains now a 0 value it returns the same structure like above but Cold is 0 instead of 120.</p>
  
  <p>But if the value for Cold is 0 I don't want to get this column and discard it that I only get the remaining values:</p>
  
  <p><a href="http://i.imagebanana.com/img/dux1gyb8/1327502046.jpg" rel="nofollow noreferrer">Example 2 http://i.imagebanana.com/img/dux1gyb8/1327502046.jpg</a></p>
  
  <p>I'm using MSSQL Management Studio 2008 and the Database is 2008 R2.</p>
  
  <p>Thanks in advance and sorry for my poor English.</p>