wait a minute...it changed format.  isn't there a way to add a table so all the values are easily viewable?

I didn't know about that feature!!  the table look great.  Thank you for bringing this to my attention.  I used 5 days look back period to keep the table small...

• This reply was modified 3 years ago by  water490. Reason: table not showing up correctly

Thank you for the feedback.  I will definitely review it.

I am not strong with SQL so I am learning as I go.

which ever is easier ... exclude or mark as NULL.  I can work with NULLs in subsequent queries.

I don't have AW DB downloaded.  Are you able to work with the...

good idea.  I have attached sample data with expected outcome

I am getting an error message.

SELECT *,

PERCENT_RANK() OVER (PARTITION BY UNDERLYING_SYMBOL ORDER BY QUOTE_DATE ROWS BETWEEN PREVIOUS 12 ROWS AND CURRENT ROW) AS PCT_RANK

FROM DBO.Stock_Log_Price_Changes

error message is

Msg 102, Level 15,...

Thank you so much!  this is great information.  I have been watching the execution plan and it is a great resource.  I will look into your resources to learn more...

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 import...

Thank you so much!

A few comments...SQL Server is definitely a very powerful program and it will take me years to really learn it well.  I am ok with that.  Life...

Thank you everyone! this is good stuff to know

.

• This reply was modified 3 years ago by  water490.

I am super new to SQL Server. I downloaded it on the weekend and transferred over my Access queries.

You bring up an excellent point.  I will take a look at...

Thanks for the reply.

I was hoping to re-use the view in another query but I have changed plans so no need to create index on view.

Thank you everyone.  I have been saving the files to a folder.  it works for me because I only have a few queries. I am so used to Access so...

Thank you everyone for the replies.  I will take a look and implement.