DataSource Controls :: Calculate Average Duration To Cover A Route Trip?
Jan 10, 2010
I want to calculate average time to cover a duration of a route.
A route can have multiple trip between different time slots.
trip have TripStartTime and TripEndTime.
For more clear of the Qns for Qns please go to this URL and for table structure please go to this Url.
Trip Time = TripEndTime - TripStartTime from columnin the table.
I have to calculate Actual trips time for different time slots group by Fleet Id which is related to route no in another table..
View 2 Replies
Similar Messages:
Feb 26, 2010
how to calculate 3 days average
View 4 Replies
May 7, 2015
I have 2 texbox and button when i type the address on textboxes it generates 2 google map using google map api and it is working fine.
I need to know how can calculate the distance between 2 addresses?
View 1 Replies
Dec 28, 2010
I am writing page to calculate the duration of dates between two ajax calender it is work outside the form view but when i but it inside form view
and if the format for the days is dd/MM/yyyy it is not work in correct way every time
this is the code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
View 3 Replies
May 7, 2015
Its relate to series of question again. I have datalist bind sql server whcih is fetching 3 address like
Address 1
Address 2
Address 3
After data list I have textbox which is based address like "Based Address"
I have the below script which calculate distance between 2 textboxex.
I want to to calculate the distance between base textbox and address in datalist item so result will like this
Base Address Pune
Datalist address
Address 1 Bombay result distance between pune and bombay 200 Km
Address 1 Kolkota result distance between pune and kolkata 500 Km
//*********DISTANCE AND DURATION**********************//
var service = new google.maps.DistanceMatrixService();
service.getDistanceMatrix({
[Code].....
View 1 Replies
May 24, 2010
ALTER PROCEDURE [dbo].[backup_database]
(
@DbName VARCHAR(250),
@dbpath VARCHAR(500)
)
AS
DECLARE @Currentdate VARCHAR(10)
DECLARE @Currenttime VARCHAR(15)
BEGIN
BEGIN TRY
SET @Currentdate =CONVERT(VARCHAR(10),GETDATE(),105)
SET @Currenttime = REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,getDate(),100),8)),8),':','-')
SET @dbpath = @dbpath +'' +@Currentdate+'_'+@Currenttime+'_'+@DbName +'.' + 'bak'
PRINT @dbpath
BACKUP DATABASE @DbName TO DISK = @dbpath
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() as ErrorNumber,
ERROR_MESSAGE() as ErrorMessage
PRINT 'Backup Could not be taken for '+@DbName+''
END CATCH
END
I want to run the above procedure at an interval of 8 hours.
View 5 Replies
May 7, 2015
I want to create a google maps that it can Calculate Distance, Travel Duration, draw (plot) Route between two locations and display Directions. Now I want to hide Directions Panel.
View 1 Replies
Dec 3, 2010
I am able to sum an entire column and put the total in a column, but what if i want to get the average of all the numbers in the column?
[code]....
View 1 Replies
Jun 17, 2010
I am trying to write some SQL to populate a gridview.
The sql should print out 3 columns:
Name, County, LastCollection (the amount of days since the last collection)
I have previously calculated the amount of days since last collection individually like this:
[Code]....
But am stuck on doing it for more than 1 record to populate the gridview which should show all the records and their last collection date.
View 9 Replies
Jun 22, 2010
I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?
ID
ContestantID
SchedularID
PublicVotes
JudgesVotes
1
4
2
4
NULL
2
2
1
1
NULL
3
3
2
2
NULL
View 10 Replies
May 19, 2010
I have a certain report I want to make where I want to calculate the slope of a dataset(turnover column) following the formula:
SumXY-MeanY*SumX / SumXX-MeanX*SumX
In order to do that the X-range has to be an integer from 1 to the last datarow. In my report I get this exact number with the rownumber(nothing) formula. But it seems I can't calculate with it in the expression for the slope because it gives errors:
=(rownumber(nothing)-Avg(Fields!TurnOver.Value)*Sum(rownumber(nothing)))/ ((Sum(rownumber(nothing)*rownumber(nothing)-avg(rownumber(nothing))*sum(rownumber(nothing)))
View 1 Replies
Jan 8, 2010
I have problem like to count the repeated chars from a string using sql server.Also i have used functions in sql server thats working fine.But i want the solution using a sql query...
[i have a column like ID,name,Secure_name],here 1 ,'kamal','welcome'.so findout 'e' howmany times repeated in a column secure_name.....
View 2 Replies
Jun 17, 2010
I need financial year in system date.actually i calculate financial year like below in VB code. [Code]....
i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.
View 18 Replies
Mar 22, 2010
We have a demand system where customer can demand the quantity they want for a particular deal.
For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity
I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.
However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?
View 3 Replies
Jan 6, 2010
my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it
[code]....
[Code]....
View 7 Replies
Jul 9, 2010
I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.
[Code]....
decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts
View 1 Replies
Mar 6, 2010
I want to calculate the current financial year in my stored procedure and use it when generating a unique Id for the customer registring in my system.
View 2 Replies
Nov 8, 2010
I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.
View 4 Replies
Jul 1, 2010
I have a gridview, I am binding the gridview with a datatable and in the gridView, my autogenerateColumn is set to true since I am generating the columns dynamically coming from database. I am also doing doing showFooter =true. There are values in the rows of these dynamically generated columns. I need to calculate the average of each of these columns and display it in the footer. so for e.g, I have
A B C
10 11 12
13 14 15
16 12 11
-- -- --
13 12.3 12.6
View 19 Replies
Feb 18, 2011
I have a table that includes a state column and a price column.
I am able to obtain the average price from a particular state using:
SELECT avg(Price)
FROM MainTable
WHERE StateId=x
I would like to display the average price from each state. The only way I know of doing this is 50 seperate datasource controls. Is there another way?
View 1 Replies
Aug 4, 2010
I am having some issues with the performance. I am binding a Gridview with around 200 records and it is taking a long time. At one time I only display 10 records on the page, but I bind all the 200 records.
Generally what is the number of records that should be bound to a gridview ?
View 2 Replies
May 7, 2010
I have a small table that has ratings for a album let's say.
Instead of showing the rating from 1-4 I want to show start instead
Rating 1 the 1 star
Rating 3 3 stars
Rating 0 no star
etc.
I have an tiny int field in the table and I will make a drop down list to allow 0-4
Currently I have a list view to show the list of comments and ratings but not sure how to convert the 0-4 from tiny int to a the same amount of stars
View 2 Replies
Mar 13, 2011
I tried to mix asp.net 4 webfrom and ASp.Net MVC 3. I add required lines in webconfig, but I've issues implementing route in global.asax
Currently I use several routes for webfroms. routs template are like below
routes.MapPageRoute("Node", _
"article/sport/{nID}/", _
"~/article/articleview.aspx")
I encounter error, when I add below lines to global.asax
routes.MapRoute( _
"Defaultss", _
"{controller}/{action}/{id}", _
New With {.controller = "Home", .action = "Index", .id = UrlParameter.Optional} _
)
I want to know how could I mix ASp.Net MVC routes with webforms routes.
View 3 Replies
Feb 2, 2010
I'm displaying a bunch of items in a ListView. Each item has a button that the user can click if he/she is not interested in the item. What I want to do is this: if the user clicks the button, I want to remove that item from the list but I don't want to necessarily make a datadabase trip for each and every item the user clicks. I'd rather make one DB trip and take care of all the items user has clicked. However, as the user clicks them, I'd like to remove them from the ListView.
View 2 Replies
Jun 2, 2010
I have created a student webpage with many tables like student info,test1 marks,test 2 marks and so on now i have to generate a report for each and every student with their details and average marks in each subject
View 4 Replies