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