Hello all. Not sure if this can be done (though usually, with computers, all things can be done lol) but I thought I would ask anyways.
I have two servers that cannot communicate with one another. One server has a temp table that I created, the other is a standard table.
I was wondering if PowerShell could select records from the temp table, then the standard table, and join them together using a third SQL statement maybe within PowerShell?