title: How to merge two rows into one row in sql?
body: <p>I have a table as</p>
  
  <pre><code>EmployeeID    IndividualPay  FamilyPay   IsActive
      1            200          300        true
      1            100          150        false
  </code></pre>
  
  <p>But I want the output as follows(I want to use this output to inner join with some other table)</p>
  
  <pre><code>EmployeeID  IndPay_IsActive  IndPay_IsNotActive FamilyPay_IsActive   FamilyPay_IsNotActive 
      1            200                 100              300                   150
  </code></pre>
  
  <p>I have looked into <code>PIVOT</code>, but not sure how to use it in my case.</p>