Compute data between record of SQL database within Visual Studio

Posted by Carl on Stack Overflow See other posts from Stack Overflow or by Carl
Published on 2010-04-26T19:08:13Z Indexed on 2010/04/26 19:13 UTC
Read the original article Hit count: 435

Filed under:

compute

|

between

|

records

Hello, I am attempting to calculate the miles per gallon for logged fuel full-ups. My table consists of the flowing:

FillUp(CarID, Date, ODReading, Gallons, StopGo, Highway, FillupID, MPG)

I want to subtract the ODReading from the previous record and divide gallons by this computed value.

How do I work between records to achieve this within Visual Studio 2008's column properties (formula) section?

Thanks much, Carl

Related posts about compute

DHCP reply packets do not make it into KVM instance in OpenStack

as seen on Server Fault - Search for 'Server Fault'
I'm running a KVM instance inside of OpenStack, and it isn't getting an IP address from the DHCP server. Using tcpdump, I can see the request and reply packets on vnet0 of the compute host: # tcpdump -i vnet0 -n port 67 or port 68 tcpdump: WARNING: vnet0: no IPv4 address assigned tcpdump: verbose… >>> More
Juju Openstack bundle: Can't launch an instance

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Deployed bundle:~makyo/openstack/2/openstack, on top of 7 physical boxes and 3 virtual ones. After changing vip_iface strings to point to right devices, e.g., br0 instead of eth0, and defining "/mnt/loopback|30G", in Cinder's block-device string, am able to navigate through openstack dashboard, error… >>> More
Java Resources for Windows Azure

as seen on SQL Blog - Search for 'SQL Blog'
Windows Azure is a Platform as a Service – a PaaS – that runs code you write. That code doesn’t just mean the languages on the .NET platform – you can run code from multiple languages, including Java. In fact, you can develop for Windows and SQL Azure using not only Visual… >>> More
Windows Azure Use Case: Web Applications

as seen on SQL Blog - Search for 'SQL Blog'
This is one in a series of posts on when and where to use a distributed architecture design in your organization's computing needs. You can find the main post here: http://blogs.msdn.com/b/buckwoody/archive/2011/01/18/windows-azure-and-sql-azure-use-cases.aspx Description: Many applications… >>> More
The Proper Use of the VM Role in Windows Azure

as seen on SQL Blog - Search for 'SQL Blog'
At the Professional Developer’s Conference (PDC) in 2010 we announced an addition to the Computational Roles in Windows Azure, called the VM Role. This new feature allows a great deal of control over the applications you write, but some have confused it with our full infrastructure offering in Windows… >>> More

Developer IT

Compute data between record of SQL database within Visual Studio - Developer IT

Compute data between record of SQL database within Visual Studio

compute

between

records

Related posts about compute

DHCP reply packets do not make it into KVM instance in OpenStack

Juju Openstack bundle: Can't launch an instance

Java Resources for Windows Azure

Windows Azure Use Case: Web Applications

The Proper Use of the VM Role in Windows Azure

Related posts about between

Categories cloud