Pretty good bet that the SQL Server Agent "service account" does not have permission to access the folder.   When an Agent job runs, it runs under the auspices of the...

Possible restrictions on the server for IE, implemented possibly by Group Policy?

Here's a solution that doesn't require the JSON functions and doesn't use REPLACE, which can be slow with large volumes of records:
CREATE TABLE #Staging (
    ID NVARCHAR(10),
    CustomFields NVARCHAR(100),

Not sure why you would ever want to connect to a later version of SQL Server from a lower version of SSMS.   As the later versions of SSMS can connect...

Sounds a little like a homework problem, so I'll ask what have you tried?   Have you considered using the REPLACE function?   As you've provided information only about a single input,...

How about using BULK INSERT ?

Why not use a windowed version of COUNT?

SELECT a.*
FROM dbo.ComplexQuery AS a
WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION BY ColumnA, ColumnB, ColumnC) = 2

If it won't let...

Jeff,

I've been reading through this topic from page 1, and I'm quite sure 121 would NOT be a member of the set, as it repeats a digit.   All...

Here's my code for this, and it runs in just 10 seconds on my Core i7 machine (2.9 GHz), 32 GB of RAM, SQL 2014:

WITH E1 AS (

Also, what I ended up doing was changing the #SELECTED_HITS table to end up having a row for each possible value from 0 to 49, based on the RangeName values...