Difference between Meterreading

Microsoft Sql server 2005 standard (full...
January 5, 2010 at 08:36:09
Specs: Windows Vista
Hey there,
I need to get the difference between each meter reading per month and return the value as Miles in another column in SQL??

July 407055
AUG 409987
Sept 412457

See More: Difference between Meterreading

Report •

January 5, 2010 at 10:09:33
If the column already exists then I would setup an On Edit trigger to do the math and post the results in the column.

Report •

January 5, 2010 at 10:22:12
What if im trying to do this thorugh a store proc ? 'm grabing the Metereading correctly but i can seem to figure out how to do the calculation part on my script.. Thanks for the help in advance.

Report •
Related Solutions

Ask Question