Yes Michael, correct. You're right that I could join on the CTRseqNo field and pull the patient ID and review date out of the parent CTRs table.

My thought behind duplicating...

I ran Phil's code, and it worked perfectly. As far as I can tell, it is equivalent to what I wrote.

I then re-executed my original code - which also worked...

I should have said "Stack Exchange" rather than SO. Stack Exchange refers to the whole group of sites with the same overarching philosophy and structure -- though Stack Overflow was...

To concur with Kathi, I agree that people need to include their DDL for the sake of  context.

My own experience on SO has been a bit mixed. Like Rod says,...

Ah, yes. If at first you don't succeed, sky-diving is definitely not for you.

MarkD

Two  - no, three - really instructive answers here.

I think Steve Collins' first suggestion was the sort of thing I had at the back of my mind. That CROSS APPLY...

I had the same question, but found the following : https://squaredup.com/content/guides/what-is-scom/

It is a bit sales-y, but has enough technical detail to serve as a starting point.

Disclosure:...

Sorted it.

Uninstalled both the 32-bit and the 64-bit AccessDatabaseEngine.exe 2016 drivers.

Uninstalled all earlier versions of said drivers.

Reinstalled the 32-bit AccessDatabase Engine.exe 2016 program from the command line using /quiet in...

My apologies, Jeffrey. I must have been skimming and missed the question at the end of your post. I just saw it now when I was checking the thread.

The answer...

Hi Ken

You have sent out many positive vibes. I am arranging to get them returned with interest.

Can't do much more from way over here, but it's a good start.

Thanks for...

I have been having another play with the 64-bit Access database engine 2016 install. It turns out that it didn't actually work properly. I have discovered the following:

1. If you...

Yes, SSC does support  tables in forum postings - that is, if you prepared to insert the BBCodes manually. It's tedious, and you obviously have to mind the syntax, but...

Hi Jeffrey, just saw your posting now, along with Phil's reply.

You can install the opposite driver using the command line and specifying either the /quiet or /passive arguments, regardless of...

Hi Phil

For my own instruction, I downloaded both 32-bit and 64-bit versions of the the 2010 and 2016 Access Redistributable .exe installation files. I presume that these are the right...

Thanks Phil, for the quick response.

I found this article yesterday, which indicates that the import/export wizards do indeed have bitness.

OK... Suppose I create and save an SSIS package with...