title: Check if a record exists in a SQL Server table using functoids
body: <p>I have two schemas. I want to check if the value (e.g. ID) in first schema exists in the second one. If it exists then update the record else insert the record into the second schema. </p>
  
  <p>How can this be done in BizTalk Server 2010 with SQL Server 2008 R2?</p>