How do I CAST a date in a subquery? Currently getting an error: Conversion failed when converting date and/or time from character string
Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail