*I think* that I understand the logic, especially since it's producing the desired results in my particular case. I will have to apply this same logic to more complex scenarios down the road which will test whether or not my understanding is correct - if it is not I will definitly come back for...
Hmm interesting, thank you very much for that - I will try this later this morning after some meetings.
I appreciate your help and will provide feedback after I try to incorporate your advice.
Say I have a table with 3 fields: TransferID, Department, and Program (ignore the fact that I don’t have a unique primary key in this example). For a given TransferID there are several records, each record containing a value for Department, and some containing a value for Program, some being...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.