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.

visitIdvisitorIdfirstNamelastNamesiteObjIdlocationcompanyNamepurposeauthorisedsiteNamecardHolderIdtypeIdempCodeempNameemailreportManagerEmailadditionalPersonsadditionalPersonDetailschkInOutIdcheckInPeriodcheckOutPeriodstartVisitDateendVisitDatevisitTypecreatedlastModifiedoperatorNamechkinchkoutvisitorStatus

11TestSubu2testtest companyNULLRoot Site113312345Athi Athitest@test.com