ePapers
Error compiling Razor Template: Failed to execute sql --URTEC BY SESSION DATA
--NEW CCUS DB TOKEN
select * from
(
SELECT
--convert(date,convert(datetime,TrueStartDate,102)) as 'TrueDate',
--FORMAT(convert(datetime,[TrueStartDate],102), 't') AS START_TIME,
--FORMAT(convert(datetime,[TrueEndDate],102), 't') AS END_TIME,
--FORMAT(convert(datetime,[TrueStartDate],102), 'dddd, dd MMMM, yyyy') AS DAY_AND_DATE,
cast(TrueStartDate as date) as 'TrueDate',
--cast(TrueStartDate as time) as 'START_TIME',
FORMAT(CONVERT(datetime2,[TrueStartDate],102), 't') AS START_TIME,
--cast(TrueEndDate as time) as 'END_TIME',
FORMAT(CONVERT(datetime2,[TrueEndDate],102), 't') AS END_TIME,
'' as 'DAY_AND_DATE',
*
FROM [dbo].[aapg_vw_Session_Details_URTEC_23CO]
WHERE
1=1
--AND Convention = 'URT23CO'
AND [Type] = 'ePaper'
)a
WHERE
1=1
and TrueDate = '2023-06-15'
and Block = 'AM'
and ArticleType = 'ZSession'
Order by --len(SessionNumber),SessionNumber,
--CONVERT(int, SUBSTRING([SessionId], CHARINDEX('-',SessionId) + 1, 4)), --THEME_ORDER,
ThemeOrder, SessionId,TruesTARTDate, CONVERT(int, abstractSort), Title (check logs for more details)