Viewing 2 posts - 1 through 3 (of 3 total)
SELECT [StartTime]
,[EndTime]
,[Active Time]
,[Pump Type]
,[emissiondate]
FROM [test2]
GO
SAMPLE...
March 18, 2009 at 6:44 am
#961788
Thanks for the quick response.
the table looks something like this 10,000+rows and 83 colums.
I will break down the columns I think I need.
StartTime=pump start time
EndTime=pump end time
EmissionDate=counts every second ,...
March 17, 2009 at 4:40 pm
#961478