Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <SQLXML xmlns="http://pilotfish.sqlxml" xmlns:ns1="http://pilotfish.sqlxml" tagNameChars="_">
  3. <Execute into="HashResults" as="HashResult">
  4. <SQL>declare @isdupeenabled smallint; set @isdupeenabled = (select top(1) isdupeenabled from pilotfish.dbo.dupecheckinbound where _kf_isa_sender = ? and filehash = ?); if @isdupeenabled is null insert into pilotfish.dbo.dupecheckinbound(_kf_file, _kf_isa_sender, filehash) select ?, ?, ?; declare @dupewriteresult smallint; set @dupewriteresult = (select top(1) isdupeenabled from pilotfish.dbo.dupecheckinbound where _kf_isa_sender = ? and filehash = ?); select case when (select @isdupeenabled) = 0 then 1 when (select @isdupeenabled) = 1 then 2 when (select @isdupeenabled) is null and (select @dupewriteresult) = 1 then 1 else 3 end as dupecheck_inbound_result;</SQL>
  5. <Params>HT000179-001</Params>
  6. <Params>guEripQAORhO8DyuIUfo7g==</Params>
  7. <Params>ad82a5a4-9dcf-4123-a89c-c74aacb4acc7</Params>
  8. <Params>HT000179-001</Params>
  9. <Params>guEripQAORhO8DyuIUfo7g==</Params>
  10. <Params>HT000179-001</Params>
  11. <Params>guEripQAORhO8DyuIUfo7g==</Params>
  12. </Execute>
  13. <XMLOut var="HashResults"/>
  14. </SQLXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement