Please Share your Product Ideas with us!

Various errors occur with the following SQL

1)  When Registering, the '+' seems to throw an error

2)  When executing the * and the @ both throw an error.

I don't have time to investigate now, but this should be investigated and handled in the processing.

BUSINESS CASE - The software shouldn't throw errors on valid SQL statements. 

SELECT     TOP (100) PERCENT dbo.stGRP_PUR_ORD_HEADER_MAP.[*PURCHASING_DOCUMENT_NUMBER], dbo.stGRP_PUR_ORD_HEADER_MAP.[*+COMPANY_CODE],

                      dbo.stGRP_PUR_ORD_HEADER_MAP.[*+PURCHASING_DOCUMENT_TYPE], dbo.stGRP_PUR_ORD_HEADER_MAP.PO_DOC_CATEGORY,

                      dbo.stGRP_PUR_ORD_HEADER_MAP.CREATE_DATE, dbo.stGRP_PUR_ORD_HEADER_MAP.CREATED_BY,

                      dbo.stGRP_PUR_ORD_HEADER_MAP.[*+VENDOR_ACCOUNT_NUMBER], dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[*+PO_ITEM],

                      dbo.stGRP_PUR_ORD_ITEM_MAP.[+ACCOUNT_ASSIGNMENT_CATEGORY], dbo.stGRP_PUR_ORD_ITEM_MAP.SHORT_TEXT,

                      dbo.stGRP_PUR_ORD_ITEM_MAP.[*+MATERIAL_NUMBER], dbo.stGRP_PUR_ORD_ITEM_MAP.[*PURCHASE_ORDER_QUANTITY],

                      dbo.stGRP_PUR_ORD_ITEM_MAP.[*+ORDER_UNIT], dbo.stGRP_PUR_ORD_ITEM_MAP.[*CURRENCY_AMOUNT],

                      dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[+SALES_DOCUMENT], dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[+SALES_DOCUMENT_ITEM],

                      dbo.stGRP_PUR_ORD_HEADER_MAP.SOURCE_ID,

                      ISNULL(RIGHT(dbo.stGRP_PUR_ORD_HEADER_ENRICHED.PURCHASING_DOCUMENT_NUMBER + 'In Current PO Load File', 23), N'In PO MAP File')

                      AS POStatus

FROM         dbo.stGRP_PUR_ORD_HEADER_MAP INNER JOIN

                      dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP ON

                      dbo.stGRP_PUR_ORD_HEADER_MAP.[*PURCHASING_DOCUMENT_NUMBER] = dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[*PURCHASING_DOCUMENT_NUMBER]

                       INNER JOIN

                      dbo.stGRP_PUR_ORD_ITEM_MAP ON

                      dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[*PURCHASING_DOCUMENT_NUMBER] = dbo.stGRP_PUR_ORD_ITEM_MAP.[*PURCHASING_DOCUMENT_NUMBER]

                       AND dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[*+PO_ITEM] = dbo.stGRP_PUR_ORD_ITEM_MAP.[*PO_ITEM] LEFT OUTER JOIN

                      dbo.stGRP_PUR_ORD_HEADER_ENRICHED ON

                      dbo.stGRP_PUR_ORD_HEADER_MAP.[*PURCHASING_DOCUMENT_NUMBER] = dbo.stGRP_PUR_ORD_HEADER_ENRICHED.PURCHASING_DOCUMENT_NUMBER LEFT

                       OUTER JOIN

                      dbo.stGRP_PUR_ORD_SALESORDER_SDDOCUMENTITEM_ENR ON

                      dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[+SALES_DOCUMENT_ITEM] = dbo.stGRP_PUR_ORD_SALESORDER_SDDOCUMENTITEM_ENR.SALES_DOCUMENT_ITEM

                       AND

                      dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[+SALES_DOCUMENT] = dbo.stGRP_PUR_ORD_SALESORDER_SDDOCUMENTITEM_ENR.SALES_DOCUMENT

WHERE     (dbo.stGRP_PUR_ORD_SALESORDER_SDDOCUMENTITEM_ENR.SALES_DOCUMENT IS NULL) AND

                      (dbo.stGRP_PUR_ORD_ACCT_ASSIGNMENT_MAP.[+SALES_DOCUMENT] IS NOT NULL)