title: SQL Server Select Case Statement with two distinct Value in two Columns
body: <p>I'm trying to do a <strong><em>Join</em></strong>.</p>
  
  <p>From <strong><em>Items Table</em></strong> which has Product Information like 
  <em>ItemID, UpcCode, Facing, ItemNameArabic, ShelfCapacity</em> everything Except <em>SERVICETYPE</em></p>
  
  <p>Joining to table <strong>Schedule</strong> which has <em>UpcCode</em> &amp; <em>ServiceType.</em></p>
  
  <p>As you see in the picture there are two rows for almost the same data except one states the <em>ServiceType</em> (Either <strong>VMF</strong> or <strong>SRR</strong> )</p>
  
  <p>What I want is Number of Rows should decrease. If you refer to the picture.
  <em>NESCAFE GOLD 50G</em> is repeated twice. Once for VMF &amp; SRR. I just want it to appear once by using either approach below</p>
  
  <p>Either it is like 2 Columns [Boolean Columns]</p>
  
  <p>a) VMF Column [If value is VMF then 'Yes' Or Else 'NO']</p>
  
  <p>b) SRR Column [If value is SRR then 'Yes' Or Else 'NO']</p>
  
  <p><strong>Or</strong></p>
  
  <p>One Column [<strong>ServiceType</strong>] </p>
  
  <p>Where it checks if it has SRR only SRR appears or else Vmf Appears </p>
  
  <p>In any of the above desired result will decrease my number of Rows</p>
  
  <p>Thank You</p>
  
  <p><img src="https://i.stack.imgur.com/3IgGz.png" alt="enter image description here"></p>