I'm not sure why the following subquery doesn't work in SQL Server, when I run the subquery by itself it works just fine, but as soon as I add I'm not sure why the following subquery doesn't
I'm not sure why the following subquery doesn't work in SQL Server, when I run the subquery by itself it works just fine, but as soon as I add I'm not sure why the following subquery doesn't