<?xml version="1.0" ?> 
<batchupdate menupath="GB_BatchUpdates" description="Update Determination date to match Sample date" 
title="Update Checked" 
>
<SQL>

Declare @EnteredBy char(16)
Declare @Custodian char(8)
Declare @EntryDate datetime


<Where keytype="Sample">


set @EntryDate = Getdate()
set @EnteredBy  <Condition field="" type="CurrentUserID" name="Current User ID"     operator="equal" /> 
set @custodian = (Select[Data] From Setting WHERE [NAME] = 'SiteId')




UPDATE Taxon_Determination set VAGUE_DATE_START= S.VAGUE_DATE_START, VAGUE_DATE_END = S.VAGUE_DATE_END, VAGUE_DATE_TYPE = S.VAGUE_DATE_TYPE, Changed_by = @EnteredBy, Changed_date = @EntryDate
FROM Taxon_Determination TDET
INNER JOIN Taxon_Occurrence TOCC
ON TOCC.Taxon_Occurrence_Key = TDET.Taxon_Occurrence_Key ANd TDET.Preferred = 1  
INNER JOIN Sample S
ON S.Sample_key = TOCC.Sample_Key
WHERE TDEt.CUSTODian = @Custodian AND S.sample_Key = '%s'  


</Where>




</SQL>
</batchupdate>