Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • Reply To: Issues with SQL Trigger

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

  • Reply To: Issues with SQL Trigger

    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...

  • Reply To: Issues with SQL Trigger

    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...

  • Reply To: Issues with SQL Trigger

    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.

  • Reply To: Issues with SQL Trigger

    Thank you.

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

  • RE: Need to trigger mail for an event

    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

Viewing 6 posts - 1 through 6 (of 6 total)