To make things a little clearer, here is that code again, but reformatted:

USE QPulse5Training;
GO

DECLARE @outPutPath VARCHAR(50) = 'C:\xp'
       ,@i BIGINT
 ...

The first problem that we have in trying to answer this is that we cannot see your database and therefore it is difficult to advise on the validity of JOINs.

Regarding...

With >3,000 points, you should know to provide a few things:

1. Sample DDL for your table
2. Sample data, in the form of INSERT statements for the table created in (1),...

That won't do it. When processing is transferred to your CATCH block, your SELECT merely returns the error message and the error is swallowed. I suggest the following slight modification:

It depends. Can you show us what is in your CATCH block?

SELECT
    [Shelf Location], date /*, ...*/FROM (
    SELECT *, DENSE_RANK() OVER(PARTITION BY [Shelf Location] ORDER BY date DESC) AS rank_num
...

Without DDL and sample data, this is largely an educated guess, but may get you started

With Ordered as (SELECT Grp = DENSE_RANK() OVER (PARTITION BY ShelfLocation ORDER...

Even 12 years ago, as far as I remember, SSIS would have to have been installed to allow the unattended running of SSIS packages, and the same is true today.

However,...

No. If you really need/want to convert the unique index to a primary key, you will have to drop the index and create the primary key - I don't...

If we were to provide the code which produced the desired results, but using your a,b,c,x,y,z data, it would work fine using this sample data, but probably not for your...

Sounds like it's encode problem, if I am honest. Perhaps, for example, you're opening the file expecting it to be encoded in UTF-16 and it's actually in ANSI-1252 or...

Here is the plan:

-log into SFTP server and download files to local directory

-unzip files to specified folder

-import files into SQL Server table (it will always be the same table)

-if...

how to handle features or  columns that i don't know it

suppose i add new feature today and every feature have column

then every feature added will modify on code

if you...

First Create your query as a VIEW:

CREATE VIEW dbo.QRY_DATES AS

SELECT ...

Once the view is in place, you can reference it from other queries.

So every time the file appears, it has a slightly different name? As long as there is only one file in the folder at any one time, this is not...