Hi,
I am trying to port over from SQL Server 2005 Express
to > SQL Server CE 3.5 SP1 (sql 2008 Commands mabee?):w00t:
Want to use a query internal to Visual Studio 2008's Query
Builder...
Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!:hehe:
SELECT [Record Number], Date, Car, Miles_Start, Miles_Stop, Gallons_FillUp, Miles_Stop - Miles_Start AS Miles_Total, (Miles_Stop - Miles_Start) / Gallons_FillUp AS MPG
FROM Sheet1_Table
ORDER BY Car, Date DESC
It processes fine but does not work: Just Want to Preform Basic math on the Data Table. Add, Subtract, Devide and Multiply.
In the "Advanced Options" of Query Builder the " Refresh The Data Table" Is greyed out... :w00t:
Any Ideas where I can get a good command reference or PDF
Book on SQL Server Compact Edition 3.5 sp1 ? 😉
Any and all help would be appreciated!