We can't generate a template that SQL Server will use because the query has a timestamp literal in it. sp_get_query_template is not converting it to a parameter and so not matching the query to the guide.
Example:
AND TRANS_DATE_TIME > { ts ''2016-05-16 10:59:49'' }
Is there a way to make a successful plan guide for a query with a literal like the above?
Thank you