program controls


afternoon presentations

Afternoon Presentations

Error compiling Razor Template: Failed to execute sql SELECT [ArticleType] ,[SessionId] ,[Type] ,[Location] ,[Title] ,[Description] ,[HostAuthors] ,[TrueStartDate] ,[TrueEndDate] ,[Block] ,[Convention] , CONVERT(CHAR(5), [TrueStartDate], 108) AS MILITARY_TIME , FORMAT([TrueStartDate], 't') AS START_TIME , FORMAT([TrueEndDate], 't') AS END_TIME , FORMAT([TrueStartDate], 'dddd, dd MMMM, yyyy') AS DAY_AND_DATE , FORMAT([TrueStartDate], 'dd MMMM, yyyy') AS JUST_DATE , FORMAT([TrueStartDate], 'dddd') + ' ' + [Type] + ' Sessions' AS DAY_SESSION_TYPE , [TeamPresentation] AS isTeam ,COALESCE([EABS], '') as 'EABS' FROM [dbo].[aapg_vw_Session_Details_ICE] WHERE Convention = 'CAE20HO' AND (('2020-06-08' = '') OR (DATEADD(dd, DATEDIFF(d, 0, [TrueStartDate]), 0)='2020-06-08')) AND (('Oral' = '') OR ([Type] = 'Oral')) AND (('PM' = '') OR ([Block]='PM')) Order by SessionId, Articletype desc, TruesTARTDate, CONVERT(int, abstractSort), Title (check logs for more details)