I modified the query so i look at part piece by piece.  the problem is with calculation

1.0 / (T1.NEAR_TERM_STRIKE * T1.NEAR_TERM_STRIKE)

the values for NEAR_TERM_STRIKE range from about 1000 to 3000.

I...

• This reply was modified 2 years, 11 months ago by  water490.

this suggestion does work

SELECT CAST(0.0000005328 AS NUMERIC(18,18)) FROM TIME_CTE

it produces:

0.000000532800000000

not sure why it doesn't work in my CTE posted.

I completely understand.  I have posted sample code.

thanks for the reply.

here is the code:

The column NEAR_TERM_STRIKE contains integers.

Even after putting the cast command I still get the same error.  There is no other column in the query...

it worked.  thank you!!

Thank you everyone.  this is very helpful

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