This'll work for access_token, provided that the access token is always quoted:

SELECT *, SUBSTRING(@JSON,NULLIF(A.S,0)+1, NULLIF(T.E,0)-(A.S+1))
FROM (VALUES(CHARINDEX('"' + @key + '"', @json))) K(CI)
    CROSS...

Personally I would go with:

SELECT YourColumns
FROM YourTable
WHERE YourDateColumn >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+1,0)
  AND YourDateColumn < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+2,0);

I assume you are using SQL Server 2014; as that's the forum you have posted in. If you are, instead, using SQL server 2016+ then you have access to

If I'm understanding correctly, the first mistake you are making is actually pivoting your data from #FileImportTypeColumn. That actually makes things a lot harder. If you return it as a...

I'm not sure I actually understand your goal here I'm afraid. What are you expected results and from what data are you expecting to get that data from? If you...

SSRS treats everything as left aligned, so if you have something that is right aligned to another object, and that other object can grow (horizontally), then the alignment will be...

Are you sure you're talking about SSIS (SQL Server Integration Services) here? This sounds more like you're talking about SSRS (SQL Server Reporting Services) considering you mention "reports" and Subscriptions...