Error compiling Razor Template: Failed to execute sql SELECT
CASE WHEN EXISTS(SELECT * FROM UserRoles
WHERE
1=1
and UserID = --12682--63
AND RoleID in(153,148,151,155,156,158,159,160,161,163,164)
and (ExpiryDate > GETDATE() OR ExpiryDate is null)
)
THEN 'Yes'
ELSE 'No'
END AS InRole (check logs for more details)