View Complete Post
I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.
I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.
Please help me guys... It will be a great help...
On occasion the incrmental crawls; which usually take under 1 minute take hours to run.
The crawl logs show a successful crawl message and the nothing til it completes, not a single log entry.
It will eventually finish and the next incrmemental will run just fine.
No errors or anything to speak of.
Index has 800K items
for Business needs i am planning to increase the session timeout to 2 hours(120 min) in one application, i am using sql server session state. if i increase to 2 hours of session time out, how it will effect the performance of application and web server.
Could any one help me on this.
I am using the below query to get difference beiween two dates in hours and minutes.Minutes part look ok but the hours is incorrect.
select datediff(minute,LastDate,getdate()) as "Minutes", datediff(hour,LastDate,getdate()) as "Hours"from emp.
Note: Using SQL Server 2005
I want to get SUM of Hours and Minutes in SQL Server 2005 in To SELECT Query Like : SELECT SUM(OTHours) FROM EmpInOutRecords.
Example: I Have OverTime Hours Like: 01:25, 02:30, 05:56, 00:50
Now I Want To SUM of This Total Hours and Minutes Like Answer is : 10:41
Please Help Me..........
Tanks in Advanced
How would you calculate the hours?Example:05:00 15:00 = 10 hours07:00 12:00 = 5 hours12:15 to 14:30 = 2 hours 15 minutes.
I have 10:45 Hours and Now I want to get Total Minutes Like 645 Minutes.
How Can I Get in SQL Server 2005?
Please Help Me................!
Thanks in Advanced..............!