Shabbaranks - Thursday, March 7, 2019 4:57 AM

Hi,
I have the following sql query

SELECT DISTINCT
                         scheme.ABC.users_text_field, scheme.efg.PAL_efg, scheme.efg.PAL_oqty, scheme.efg.PAL_product, scheme.efg.PAL_date,
                         CASE WHEN scheme.efg.PAL_product = '000' THEN 'Test 1' WHEN scheme.efg.PAL_product = '999' THEN 'Test 2' WHEN scheme.efg.PAL_product = '888' THEN 'Test 3' WHEN scheme.efg.PAL_product
                          = '111' THEN 'Test 4' WHEN scheme.efg.PAL_product = '222' THEN 'Test 5' WHEN scheme.efg.PAL_product = '333' THEN 'Test 6' END AS ProductName, scheme.efg.PAL_porder,
                         scheme.efg.PAL_bin, scheme.xyz.users_text01, scheme.xyz.users_text02, scheme.xyz.users_text03, scheme.xyz.users_text04, scheme.xyz.users_text05, scheme.efg.PAL_insp_name,
                         scheme.LMN.alpha
FROM            scheme.efg INNER JOIN
                         scheme.ABC ON scheme.efg.PAL_efg = scheme.ABC.users_text_field INNER JOIN
                         scheme.xyz ON scheme.ABC.lot_number = scheme.xyz.lot_number INNER JOIN
                         scheme.LMN ON scheme.efg.PAL_porder = scheme.LMN.order_no
WHERE        (scheme.efg.PAL_product LIKE 'R00%')
Which runs fine, if I try and filter on the date column as below
WHERE        (scheme.efg.PAL_product LIKE 'R00%') AND (scheme.efg.PAL_date = CONVERT(DATETIME, '2019-04-03 00:00:00', 102))
It errors with a time out. If I leave it without the date filter and try to filter within SQL Server Report Builder it also times out.

Any ideas how to get around this?
Thanks