top of page

SQL query from last 30 minutes

  • Writer: skarbnik
    skarbnik
  • Nov 4, 2015
  • 1 min read

SELECT top 1 [RECORD_ID]

,[UCID]

,[MODULE_NAME]

,[STARTDATETIME]

,[ANI]

,[PHONE_NUM]

,[DNIS]

,[CUST_LANG]

,[IVR_POINT]

,[EVENT_TYPE]

,[EVENT_VALUE_1]

,[EVENT_VALUE_2]

,[EVENT_VALUE_3]

,[EVENT_VALUE_4]

FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN]

where [STARTDATETIME] < GetDate() and [STARTDATETIME] > dateadd(minute, -30, GetDate())

--DATEDIFF(n,CAST([STARTDATETIME] as datetime),GETDATE())<=60

order by [STARTDATETIME]

desc

 
 
 

Comments


Search By Tags
bottom of page