title: Sql Server 2008 MERGE - best way to get counts
body: <p>I'm wondering what y'alls would recommend as the best way to go about getting the action counts from a MERGE statement in Sql Server. </p>
  
  <p>So, i.e. I run a MERGE which does some inserts, some updates and some deletes, ... I would like to be able to find out HOW MANY inserts, HOW MANY updates and How Many deletes. </p>
  
  <p>What'd be the best way to do this?</p>