var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedure running total
What's the best way to create a field with a running total in a stored procedure:
SELECT TestDate, ZValue,
ZRunTot = ZValue + Last ZRunTot ????? Do I use Define + Select?
This should work as long as TestDate values are unique:
sum(Previous.ZValue) as ZRunTot
inner join tblTest Previous on Previous.TestDate <= tblTest.TestDate
group by tblTest.TestDate, tblTest.ZValue
I'm getting some strange results ... does the tblTest file need to be sorted by the Date prior to the SELECT?
Works perfectly .. thanks a bunch