Viewing 3 posts - 16 through 18 (of 18 total)
I'm pretty sure Jonathan AC Roberts has is right in his original post, the iType = 1 in the NOT EXISTS subquery is what's throwing you.
You're correct that the code...
January 7, 2020 at 3:27 pm
If you have a dbo.C table/view in the database the query will run ok.
November 8, 2019 at 10:39 am
Yes, you need to use the Decision1 subquery in the WHERE clause in place of Decision1. Decision1 in the query you have written is a column alias, meaning the column...
September 10, 2014 at 7:26 am
Viewing 3 posts - 16 through 18 (of 18 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy