varchar did the job.  thank you!

they are definitely INTs...

the field only has two values 5 and NULL/empty

The example I gave (,-0.0143,3965.54,3986.34,0,,,,,) are for the record.  the problem areas are the ,, ones.  Excel shows nothing. ...

i am seeing this

,-0.0143,3965.54,3986.34,0,,,,,

How do i address this?  VARCHAR approach as suggested earlier? or a different one?

good question.  that is hard to tell.  the data is coming in the form of an excel csv file.  the cell is definitely empty.  is there a way to know...

The field only has two values 5 and NULL.  I think INT is big enough to store it.  I'll try the VARCHAR approach...thx for the idea

One more thing...

I use the Tasks -> Import Data wizard and I don't change any of the options (other than manually mapping certain fields from the CSV to import table...

i don't know what that is so i have not used it

I am using Filezilla.  Yes it can be operated via command line

I got this working with a SUM

SELECT *,

SUM(PRICES) OVER (PARTITION BY SYMBOL ORDER BY QUOTE_DATE ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS CURRENTANDPREV3

FROM DBO.Stock

It produces the sum as noted. ...

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 2 years, 10 months 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,...