Thanks, I'm adding the schema name (dbo) and will get back to you with results.
I'm starting to think this is an execution plan issue such as parameter sniffing.
As a beset practice, do you always include schema names for all queries even if the customer only uses the default dbo?
Thanks in advance for your valued feedback,
Andre Ranieri