mingo | MongoDB query language for in-memory objects | Functional Programming library

I have a simple React Native application that utilizes an AWS bucket for photo storage. I currently have the AWS config coded in a file in which it is being used but I would like to move it to it's own file and then import it when needed.

This is what the config.js file looks like when abstracted from the other files:

I have an ASP.NET FX application hosted on an IIS server. On the server, and only on the server, not in Visual Studio IIS Express, when loading the 'Create' page I get this error:

Long Story short. I have data that I'm trying to identify duplicate records by address. The address can be matched on the [Address] or [Remit_Address] fields. I use a JOIN and UNION to get the records, but I need the matched records to appear with each other in the results.

I can't sort by any of the existing fields, so a typical 'ORDER BY' won't work. I looked into RANK as suggested by someone and it looks like it might work, but I don't know how to do the Partition, and I think the Order gives me the same issue with ORDER BY.

If RANK is not the best option I'm open to other ideas. The goal ultimately is to group the matched records someway.

• SSMS 18
• SQL Server 2019

Here is the setup:

Backstory: I have created a bunch of stored procedures that analyze my client's data. I am reviewing a list of vendors and trying to identify possible duplicates. It works pretty well, but each record has 2 possible addresses, and I'm getting duplicate results when matches are found in both addresses. Ideally I'd just need the records to appear in the results once.

Process: I created a "clean" version of the address where I remove special characters and normalize to USPS standards. This helps me match West v W v W. or PO Box v P.O. Box v P O Box etc. I then take all of the distinct address values from both addresses ([cleanAddress] and [cleanRemit_Address]) and put into a master list. I then compare to the source table with a HAVING COUNT(*) > 1 to determine which addresses appear more than once. Lastly I take that final list of addresses that appear more than once and combine it with the source data for output.

Problem: If you view the results near the bottom you'll see that I have 2 sets of dupes that are nearly identical except for some slight differences in the addresses. Both the Address and Remit_Address are essentially the same so it finds a match on BOTH the [cleanAddress] and [cleanRemit_Address] values for "SouthWestern Medical" and "NERO CO" so both sets of dupes appear twice in the list instead of once (see the desired results at the bottom). I need to match [cleanAddress] OR [cleanRemit_Address] but I don't know how to limit each record appearing once in the results.

• SSMS 18
• SQL Server 2019

Queries:

I have a props object which will contain an unknown set of properties, some of which I want to extract based on their prefix. I have something that works (great!) but it seems long-winded, and I want to know if there's a more idiomatic way of doing it?