FOr this query I have four tables I would like to access.
SUM(Score) AS Total
WHERE [When] >= @StartTime
AND [When] < @EndTime
GROUP BY StockA
ORDER BY SUM(Score) DESC
_LongPrice, _ShortPrice, _LongVolume, _ShortVolume
I would like to improve the above query to return not just the results from LongPrice, but four columns, of sum(score), from each table, if possible.
And, if that is possible, I would also like to have the query then update another table with its results. Not a new table, but just updated to an existing table.
Anyway, I can do some stuff in T-SQL but this seems over my head. Any help would be appreciated.
(The four tables all have identical structures)
View Complete Post