Hi Lynn, just now reading this article due to the re-publish. If you have a table with a high rate of transactions, what do you think of using the READPAST...

Thank you.

The t1 table has no index on the n column, thus when you do the left join on "A.ID - @Period = B.ID" it is doing a full...

Digs I'm not trying to be a jerk here, but if you want me to help you, you need to provide code that reproduces the problem you are having issues...

Digs, can you please post the entire code you are using?

Also in retrospect, I would not create t1 as a CTE, as lately when I use Row_Number() in a CTE,...

Thank you that did the trick.

greg 2201 (9/23/2010)

---

I'd be interested to know whether anyone has an approach to calculate time-based moving averages where the time stamps are irregularly spaced. This is how financial data...

Chris -

That's very nice work. I ran it on the code I used in the article, and modified all the decimal variables/fields to (8,2) and it provided just as good...

sven.purbe (3/8/2010)

---

May I suggest some improvements to the outlined solution.

First I would prefer to store the stock quotes as integers (multiply by 100) - less storage space needed which also...

TimvdH (3/4/2010)

---

Great work, thank you! Would love to read more about technical analysis and sql. Or even better: portfolio theory and sql. BTW: does someone know if using MDX /...

Hey does anyone know if it's possible to do this solution but insure that the fields/variables are updated in a specific order for each row?

Like say I have a...

They...

-deleted-

Hey everyone, thanks for your posts. You all will probably be dissappointed but I've decided to instead use .Net (either via SSIS's Script Task or a Client App) in order...

Jeff is always ahead of the game. Thank you Lynn. Numbers being off is the least of my concerns - I just needed to see a way to carry numbers....

Sure

input_number,weight,weighted_average

00,1.00,20.00

13,0.25,18.25

18,0.10,18.22

51,0.18,24.12

23,0.20,23.90

21,0.23,23.23