DEV DATA
select EVENTID,OWNERID ,OWNERTYPE ,EVENTNAME ,EVENTPROCESSED ,EVENTSUBJECTID ,EVENTSUBJECTTYPE ,EVENTTIME ,EVENTUSERID ,PROCESSEDTIME, eventData ,PROCESSINGTIMEMS,EVENTDATA, errorOccured from tbl_SYS_Events with (nolock) where eventname in ('skuSpecAdded','skuSpecUpdated','skuSpecRemoved') and year(eventtime) = #year(now())# and month(eventtime) = #month(now())# and day(eventtime) = #day(now())# order by eventTime desc
EVENTID OWNERID OWNERTYPE EVENTNAME EVENTPROCESSED EVENTSUBJECTID EVENTSUBJECTTYPE EVENTTIME ERROR PROCESSEDTIME PROCESSINGTIMEMS
#qry_getData.EVENTID# #qry_getData.OWNERID# #qry_getData.OWNERTYPE# #qry_getData.EVENTNAME# #qry_getData.EVENTPROCESSED# #qry_getData.EVENTSUBJECTID# #qry_getData.EVENTSUBJECTTYPE# #qry_getData.EVENTTIME# #qry_getData.errorOccured# #qry_getData.PROCESSEDTIME# #qry_getData.PROCESSINGTIMEMS#