I moved the conversion into the query, instead of trying to do it at time of setting the param and now the conversion works.

...

...

top article: JOIN, EXISTS, IN capable of producing the same stats.

Gail. Exists doesn’t check for a match, it doesn’t care in the slightest what values are been returned from the...

peitlinden's ends up working better for me because it allows me to order the dates within the partition, but that wasn't part of the ask....:-)

Jason and peitlinden. both marked as answer. Thanks much for help.

Regarding 'correlated queries are your friend'....seems to be true lately, peitlinden. Thanks for sticking by.

ok pietlinden, I can use your query and then union all results to original query, but do you have insight on how to pull the date of the move ie....

hi pietlinden.

Your query works to extract the lead_id having been moved into a property it was referred to, which is cool becuase you understand the logic, but I'm looking...

thank you gward, davo collective, and matt miller for further clarification.

This experience has led me with conviction to understand that in the scenario where I was seeing the...

I guess you're not in Kabul, then.

OK.

so I incremented the JOIN condition in Eirikur's LEFT JOIN example and found that the entire left table is returned, whether the JOIN condition...

My current latest understanding:

In Left Outer JOIN everything is returned, period. That's because it's not an INNER JOIN but a LEFT OUTER.

Next, if there is a WHERE clause, results are...

Hi Lynn, thanks for bearing with me.

the persontype comes from Person.Person. I aliased. Can you revise the explanation?

freakin' frustrating.

This looks simple enough and I understand the sentences and logic, but...

Lynn, when I try the EXCEPT I get error:

"

Msg 421, Level 16, State 1, Line 3

The xml data type cannot be selected as DISTINCT because it is not comparable.

"

[/

SELECT

...

nope, it literally returns all records from the right hand side regardless of join or filter, right?

(1) the LEFT JOIN to Person.Person table returns everything from Person.Person that satisfies the JOIN condition (p.BusinessEntityID = st.BusinessEntityID) and the filters for persontype and dates.

(2) the AND usage retrieves...