hi all

still i cant find the solution. please help me out.

this part get the latest seqno from table EPOSSDataExtractSequence, this seqno update every 40 min, once the scheduler run and generate file.

declare @seqno as int

SELECT @seqno = S.ExtractSequenceNo

FROM EPOSSDataExtractSequence S INNER JOIN EPOSSyncOrderMaster M

ON S.MasterCategory = M.MasterCategory

WHERE M.SyncTableName = 'GH_Account_Master_Transfer_Staging'

print @seqno

this part update the latest sequence no from the table EPOSSDataExtractSequence

UPDATE GH_Account_Master_Transfer_Staging

SET SeqNo = @seqno + 1

FROM INSERTED

WHERE

GH_Account_Master_Transfer_Staging.SourceDocNo = INSERTED.SourceDocNo

AND GH_Account_Master_Transfer_Staging.SourceFiscalYear = INSERTED.SourceFiscalYear

AND GH_Account_Master_Transfer_Staging.SourceLocationCode = INSERTED.SourceLocationCode

END

please suggest some idea.