Also, my brain was thinking about that wrong.  What DinoRS put is correct in that "Or in other words: Show only results where you have more than one resultset...

The WHERE clause is saying "WHERE 1 < (a set of data)".  The subquery is likely going to return more than 1 value UNLESS you only have 1 salesman_id...

• This reply was modified 3 days, 19 hours ago by  michael.leach2015.

Jeff,

Thank you for your input.  I'm glad I asked these questions.

With all the replies I am still unclear about which language type SELECT really falls under.  Just to be sure,...

Again... teaching a man to fish. 😀

If you do a search for "subqueries in sql server" and look for the "Microsoft Docs" (BOL) entry in the returns, you'll end...

Brian,

Yes, you're right.  In that first example I had it would return only one row instead of many.  I can't believe I overlooked that.  Many times, when I get an...

Jeff,

Thank you for your post.  I can tell it took a while to write it.  Before I do a post, I try to look at the online documentation first.  I...

Nevermind.  I see what I did wrong.  Only the schema and table should be in the FROM clause.  The column names should be in the SELECT statement.

To answer question number 2 about the folders, those are version numbers.  110 is 2012, 140 is 2017, 150 is 2019.

If you installed SSMS 18, it does not come...

I should have mentioned that I am installing SSMS on my personal laptop.  When you download SSMS I thought that SQL server is automatically installed also.  I'll try downloading SQL...

Also, what are these folders that are numbered, such as 110, 140, etc?  What do these folders represent?

Program Files\Microsoft SQL Server\110

Program Files\Microsoft SQL Server\140

Program Files\Microsoft SQL Server\150

Since you didn't use a variable on the left side of the "=", you've changed it to a column assignment.  Since the variable had no assigned value, it went...

I don't know about that.  I don't think XML will be on...

Jeff,

I think I'm pretty much ready to test for the Microsoft 98-364, Database Fundamentals exam.

Just to be really sure I will pass it, I'm studying for the Microsoft 70-761, Querying...

• This reply was modified 1 month, 2 weeks ago by  michael.leach2015.

That makes sense.  I'm not sure what happened there, but this is helpful.  Thank you.

Jeff,

Yes, I saw that part about returning various numbers.  I think I might have misunderstood what is meant by the procedure generating an error.  I took that to mean if...