Viewing 9 posts - 46 through 54 (of 54 total)
No problem. Below is the solution that I ended up using:
-SOLUTION---------------------------------------------------------------------
UPDATE a
SET Avg1MoVol=(SELECT AVG(b.Volume)
FROM tblHistoricalData b
WHERE b.SymbolID = a.SymbolID AND b.MarketDate a.MarketDate-31)
FROM tblHistoricalData...
December 8, 2008 at 12:43 pm
I think I've got it now, I'm still really new to SQL and learning as I go...
Thanks again for all your help!
December 8, 2008 at 10:03 am
Sorry, looks like the code didn't paste correctly the first time - it read the 'less than' and 'greater than' as HTML brackets. Should be:
UPDATE Test_HistoricalData a
SET...
December 8, 2008 at 9:11 am
Test_HistoricalData is just a copy of another table, I wanted to make sure I had this running correctly before making changes to my real table. I didn't copy over...
December 8, 2008 at 9:09 am
Thanks for the help! This way seems to be the most efficient so far... so I tried incorporating it into an "Update" to populate a column called: Avg1WkVol...
December 8, 2008 at 9:00 am
Thanks for the help - I used your solution and then ended up fixing my own and coming up with another.
I'm posting the solutions below...
These solutions all...
December 8, 2008 at 7:02 am
If I'm understanding what you suggest correctly, then I still need to repeat this process for each one of the tables I am updating, right?
Is there a way...
December 1, 2008 at 10:55 am
From what I'm reading about transactional replication, it would seem that the remote Database A would have to be set up as a distributor and the publications created there. ...
November 24, 2008 at 2:51 pm
Viewing 9 posts - 46 through 54 (of 54 total)