Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <SQLXML xmlns="http://pilotfish.sqlxml" xmlns:ns1="http://pilotfish.sqlxml" tagNameChars="_">
- <Execute into="HashResults" as="HashResult">
- <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>
- <Params>HT000179-001</Params>
- <Params>guEripQAORhO8DyuIUfo7g==</Params>
- <Params>ad82a5a4-9dcf-4123-a89c-c74aacb4acc7</Params>
- <Params>HT000179-001</Params>
- <Params>guEripQAORhO8DyuIUfo7g==</Params>
- <Params>HT000179-001</Params>
- <Params>guEripQAORhO8DyuIUfo7g==</Params>
- </Execute>
- <XMLOut var="HashResults"/>
- </SQLXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement