I don't need to see your query. What we need to see are your desired results, based on the sample data provided. You seem unwilling to do this.

That is confusing.

Based on your sample data, please provide a screenshot of the results you would like...

Please explain why TOP (2) is not to be used.

Can you show us a screenshot of the Lookup configuration?

So what? The advice provided by Ed B is sound. Perhaps...

Well, there is something that you can do. Whether it helps you at all is a different matter, but I'll mention it just in case.

If you do the following, your...

I ended up with something like this. Do you see any issues I would run into?

As I have completely failed to grasp what it is you are going to be...

I believe that most people structure their table definitions with key columns first, which may explain why I have never seen this behaviour before.

That means you have some data which does not follow the convention. You can avoid the error by filtering out the rows which do not match, like this:

            
February 21, 2022 at 2:06 pm
            
#3986423

            
            
                                                
        

Hi Phil.

Many thanks for coming back on this. It drives me crazy...

It happens at least in VS 2019 and 2020, which I've checked. I have several tables with such...

If the data really is as well structured as your examples suggest, the following should work. If not, something more refined will be required.

DROP TABLE IF EXISTS...

I need to parse payment data from a notes field. Example of data below.  I tried the Len function but got mixed results, Any help or examples would be...

The column is defined for every row of data in the table, therefore the idea of...

Which version of SSDT?

Have you got any other tables with clustered columnstore indexes on them? Is there something special about this table, or does it happen for every table like...

I suggest it's worth having both 32- and 64-bit versions installed.

Take a look here to see how to do that (it's not as straightforward as you might think).