How do I move only the new data to new table?

The requirement is export the rows to a text file in a path when it meets the condition. Like say when there is a transaction of particular store, the row...

Yes for my testing, I have database called tesdb and testing it by manual insert. So if this is not the right way of doing, can you please advise on...

Are you able to provide me a sample on how to do this. I need the text file on live when the row is inserted.

Thank you.

Can you please provide sample steps. I haven't done this before.

Hi

Can we create a SP to achieve the requirement?

Below is the query which i am using to fetch data.

select * from euromaster..vw_vischeckinout

And the result is below.

visitId visitorId firstName lastName siteObjId location companyName purpose authorised siteName cardHolderId typeId empCode empName email reportManagerEmail additionalPersons additionalPersonDetails chkInOutId checkInPeriod checkOutPeriod startVisitDate endVisitDate visitType created lastModified operatorName chkin chkout visitorStatus

1 1 Test Subu 2 test test company NULL Root Site 1 133 12345 Athi Athi test@test.com