I have a TI process which uses an ODBC data source.
The SQL is constructed on the prolog.
If I use the following code in the Where Clause the process runs fine in a few seconds without any issues:
Code: Select all
'AND [ElementName] = ' | CHAR(39) | 'Pension Salary Sacrifice' | CHAR(39) | ' ' |
Code: Select all
'AND ([ElementName] = ' | CHAR(39) | 'Pension Salary Sacrifice' | CHAR(39) | ' or ' | '[ElementName] = ' | CHAR(39) | 'Pen Adj +' | CHAR(39) | ') ' |
It should be noted that when running the query in sql server the same code runs in around 33 seconds.
Has anyone seen this issue before, it feels like a bug to me?
Maren