A view, I understood a view was a no no !

Question how can I use a procedure to populate a SELECT ??

Thanks 🙂

Thanks..:-) 🙂 🙂

I need to run this over about 20,000 records once per day.

I assume this wont blow up. 😉

Nice stuff...

ALZDB, can you have a look at this calculation ..for me...

http://www.sqlservercentral.com/Forums/Topic1019024-1291-1.aspx?Update=1

Thanks 🙂

This is more that a running total, its an index calculation, and I have no idea what all article means..

Thread closed, thanks !:-)

Thanks..

Another complication to add,..if you could be so kind...

Add field :valdiffCum (cumulative difference index)

CREATE TABLE #myTable(

dt DATETIME,

val DECIMAL(12,4),

valdiff DECIMAL(12,4),

valdiffCum DECIMAL(12,4)

)

DECLARE @CumStart DECIMAL(12,4)

SET @CumStart = 100

Add up the valdiff to got...

Thats stuff is 1000 miles over my head...

More direct help would be nice...

Thanks for that advice, thats something they didnt tell me...

Ok..

Thanks

Roger that !:-)

Lutz,

With your method, how does one get monthly data ???

Jeff I get an Error when I run your code

FROM dbo.Tally t

INVALID OBJECT !

Jeff and or Lutz

If I have data in a table, with a Date as the Primary key.

And data is currently IN ORDER ASCENDING.

If I do a

SELECT * FROM <TABLE>

ORDER...

Thanks for the effort lads.

1) NO data on weekends, as NYSE, AMEX and NASD are closed on these days. Lets hope they remain so !

2) Weekly data must end with...