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

If the column already exists then I would setup an On Edit trigger to do the math and post the results in the column.

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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History