i have this search:
SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),' ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY"
WHERE C_CREATED_DATE_TIME > ?
ORDER BY C_CREATED_DATE_TIME ASC
and i want to add
and
clause to the where section.
for some reason it doesn't work.
i tried:
SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),' ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY"
WHERE C_CREATED_DATE_TIME > ?
and C_CREATED_DATE_TIME > convert(varchar,'2022-08-31',121)
ORDER BY C_CREATED_DATE_TIME ASC
and i tried:
SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),' ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY"
WHERE C_CREATED_DATE_TIME > convert(varchar,'2022-08-31',121)
AND C_CREATED_DATE_TIME > ?
ORDER BY C_CREATED_DATE_TIME ASC
both didn't worked.
any advice?
The problem was with the data itself (heavy).
Issues can be closed