There are two tables 1)HR_OrderRequest (column to be considered is HRdate) other columns are HRUID,UID
2)HR_Supplydetails(colmn to be considered is HRUID) other columns are createddttm,UID
by considering the date from HR_Supplydetails we should find the average days taken for that particular UID time taken to release of HRdate .I have a problem getting a average of days
how to calculate 3 days average
View 4 RepliesI 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]....
How to calculate no of days, month and working days
from date
Date1 is Enrolled date
Date 2 is todays date
So I want to calculate no of days and month and working days excluding saturday and sunday
Date1 = 10/01/2012
date = 12/05/2012
I want ans as : total days : 65 days
Month : 2 month 5 days
working days : 48 working days
There is a calendar control in asp.net
For selection mode, there is day, dayweek and dayweekmonth.
But I wanna select randomly like every monday for the selected month.. something like that.
For that, I need to do the custom method.
I would like to get number of Year, Month and Days by Given days.
Eg:- My input is 400 out put like as 1 year 1 Month and 4 Days.
How to do it?
I am facing a different problem in using Ajax Calendar..
i.e., I am using ajax calendar properly
but whenever i am click calender image it displays ajax calender only 5 days instead of 7 days...
The preview of calendar is shown below
[URL=http://www.lazypic.com/view.php?filename=56ScreenShot.jpg][img]http://www.lazypic.com/images/56ScreenShot.jpg[/img][/URL]
how can we find avg in matrix row wise? that is i want find the average of data at the end of a row.
View 1 RepliesLast night I did a load test on a site. I found that one of my shared caches is a bottleneck. I'm using a ReaderWriterLockSlim to control the updates of the data. Unfortunately at one point there are ~200 requests trying to update the data at approximately the same time. This also coincided with CPU usage spikes.
The data being updated is in the ASP.NET Cache. What I'd like to do is if the CPU usage is around 75%, I'd like to just skip the cache and hit the database on another machine.
My problem is that I don't know how expensive it is to create a new performance counter to check the cpu usage. Also, if I would probably like the average cpu usage over the last 2 or 3 seconds. However, I can't sit there and calculate the cpu time as that would take longer than it's taking to update the cache currently.
Is there an easy way to get the average CPU usage? Are there any drawbacks to this?
I'm also considering totaling the wait count for the lock and then at a certain threshold switch over to the database. The concern I had with this approach would be that changing hardware might allow more locks with less of a strain on the system. And also finding the right balance for the threshold would be cumbersome and it doesn't take into account any other load on the machine. But it's a simple approach, and simple is 99% of the time better.
I have two datetime2(1) fields in my db. I will calculate the time in hours and minutes between them. That I have done this way:
[Code]....
This works. But how can I calculate the avgerage speed if I have drived 665 kilometers in this time? I know how to do it with only houurs but not with the minutes to. I have tried this and I think it works. Is it correct?
[Code]....
There are various website speed test online tools available. Few of them are listed on: [URL] I tested my website using iweb and selfseo. My website is showing 0.03KB Average speed per KB everywhere. Even google also is giving same kind of results.I tested the site using Page Speed and YSlow. I have already followed most of the recommendations suggested by these tools like efficient use CSS, contents across the domains, caching, compression and all. But still I am getting the same average speed per kb. Page speed is showing around 85/100 as my page speed score, so I guess I have optimized my site a lot. My questions here are:
1. What are the other factors affecting the avg speed per kb of a website?
2. How to improve the Avg speed per kb?
3. Is there anything related with the Server Software and Hardware that I have to check?
Note: I tested by uploading a plain html page with simple text "Hello World", but the avg speed per kb is the same for this page as well. Same is the case with the rest of the pages.
Application Platform : ASP.Net 3.5, C#3.0, LINQ as Data Access, SQL Server 2008
Server Platform : Windows Server 2003.
how can we find average at the right side of datas in a matrix. I created matrix and by right clicking on the cell , there is 'Subtotal' But after cliking that dont get any sum, but only last value is displayed as sum. How can i resolve this?
View 1 RepliesI 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
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?
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 ?
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..
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
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 RepliesI have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 RepliesI am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 RepliesI make use of SMO namaspace to get Table, Function, Procedure names from the DB.
Now I've intended to get the tables [Column] name and the relation (dependency) among the tables. Is this possible?
I have enddate with dropdown, the dropdown values like this 3months,6months,9months, 1 years, 2years.....etc. my start date is now date .
so how can i get days difference between from startdate and selectedperiod?
If I were to run some code, perhaps send an email, every 30 days to users of my site, how would that be done?
View 5 Replieshow to get days difference between two dates in asp.net
View 3 RepliesI would like to make a function to return a information based on the current date and a process.So my parameters was just NOW() and the Process. For example to process AAA and the date '2011-03-27', I would get the stat 'normal' cause day 27 is between 4-28. (Doesn't matter the month)return case when ((@day >= @INI_DAY OR @day <= @END_DAY)) then @STAT else '' end;OR @day between @INI_DAY AND @END_DAY not works
ID Process Stats DayStart DayFinal
15 AAA Critic 1 3
16 AAA Normal 4 28
17 AAA Critic 29 31
18 BBB Critic 1 25
19 BBB Fail 25 31