There is a Postgres forum here. I am sure that there are others. Why not ask questions like this in a forum where the other people use the same...

Yeah, that makes sense. But if the code is all in a single DB at the moment, I can't see why a linked server would be needed. Why not a...

I can't think of a great way of handling this – sounds like you've considered the possibilities.

Presumably you've discounted the idea of keeping your custom code in a completely separate...

Here is another way.

If you do something like this in PoSh, to create a delimited text file, it is then very easy to import the results in tabular form.

            
September 18, 2023 at 5:37 pm
            
#4289004

            
            
                                                
        

Does Jonathan's (excellent) response solve your problem?

+1, this has the added benefit...

Put the date into YYYYMMDD format before casting and it should work.

DECLARE @x VARCHAR(100) = '09142023';

SELECT @x
      ,SomeDate = CAST (CONCAT (RIGHT(@x,...

Here is a possible approach.

1. Get the code for your DB into a VS database project and check that into a DevOps Git repo.
2. Set the database project to target...

If you would provide just 10 rows of sample data, in consumable format, it would help a lot.

Presumably, your question is not this:

"Why are no results returned when I join on two columns containing values which do not match?"

What is your real question?

The issue is, all of these tables dont have primary/secondary keys, which i brought in with sl code.

Because these keys dont correspond to one another it gives me these...

Like this?

WITH ordered
AS (SELECT *
          ,rn = ROW_NUMBER () OVER (PARTITION BY adc.channelid ORDER BY adc.recordcount DESC)
 ...

You seem to have a lot of Postgres problems ... why not find a Postgres forum?

There is a button that says 'Code' in your icon bar. With >3,000 points, you...

1. Repair Microsoft Visual Studio Tools for Applications. This is a common solution that has worked for many people. To do this, open Control Panel and go to Programs...

Run the package in Visual Studio and add some data viewers in the data flow to find out what's going on and where the missing data is going.

I suggest changing...