SQL show results as NAME
- skarbnik

- Nov 4, 2015
- 1 min read
SELECT [UCID] ,[STARTDATETIME] ,[ANI] as 'PHONE Number calling' ,[PHONE_NUM] as 'Identification Phone' ,[EVENT_VALUE_1] = case EVENT_VALUE_1 when 1 then 'TV' when 2 then 'INT' when 3 then 'TEL' else null end FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN] where [STARTDATETIME] between '2014-09-01' and '2014-09-15' AND ([EVENT_VALUE_1] = '1' or [EVENT_VALUE_1] = '2' or [EVENT_VALUE_1] = '3') and ([IVR_POINT] = 'A120.1.3' or [IVR_POINT] = 'A120.1.2' or [IVR_POINT] = 'A120.1.6' or [IVR_POINT] = 'a120.6') order by [STARTDATETIME]

Comments