IIS Configuration :: Calculate Number Of Leaves Taken By Employee In A Month In SQL Server
Mar 18, 2013
i wrote a stored procedure to display the number of days in the particular month.if the person is taking a leave from 26jan to 03feb,using this stored procedure i will split the days as per the months..now i want to pass the employee id in the stored procedure and retrive the total days of the january month this is my code
this is my stored procedure
ALTER PROCEDURE datecheck
@EmpId int,@startdate datetime,@enddate datetime
as
begin
[Code]....
i am having dropdownlist in my webpage,if i select the employee id and month january it will retrive the january days for the particular employee.....
View 1 Replies
Similar Messages:
Jan 15, 2013
I want to calculate the number of days an employee has taken leave in the month of january.For that I have two date fields Leave_Start_Date and Leave_End_Date in the database as follows:
Leave_Approval_Id Leave_Start_Date Leave_End_Date EmpId
1 2013-01-25 00:00:00.000 2013-02-10 00:00:00.000 10
View 1 Replies
Dec 6, 2012
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
View 1 Replies
Feb 25, 2011
How to calculate current date(month) minus one month in crystal report?
View 1 Replies
Dec 11, 2012
How to display the number of days in textbox when the month is selected in the dropdown list,,,for example if i select the month december ,after selection i want to display 31days in the textbox how ?
View 1 Replies
Sep 2, 2010
I want to bind data(For ex: Employee name, Employee ID from Employee) to a dropdownlist and the data should be displayed in dropdownlist as two columns. I don't want to separate this columns by using any special characters like | or '-'. I want to display them as different columns in a dropdownlist.
How can i achieve this using .net and the data i need to retrieve using SQL server 2008.
View 2 Replies
Sep 17, 2010
i have a website which has 3 modules admin part,employee part and customer part . so when the admin login he has to see the number of customers logged in and the duration etc excluding employee and admin
View 4 Replies
Jan 31, 2011
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?
View 5 Replies
Jan 13, 2011
I was wondering if there is any way to always run some server side code when a user leaves a page in ASP.NET. The page Unload event is no good because that doesn't get called if someone clicks on a link. Ideally I'd also like the code to run even if the user closes the browser.
View 4 Replies
Jul 29, 2010
how to get the days for particular month and year
Given the following method:
GetDaysPerMonth(string monthName, string year);
And the values "1" and "2010", how can I return the number of days within the specified month?
View 3 Replies
Feb 9, 2011
Is it possible to display this as the name of the month and not the number?
[Code]....
So I would like to see it as January when used in a variable like
Dim strMonthName as String = System.DateTime.Today.AddMonths(-1).Month
View 1 Replies
May 31, 2010
I have 2 textboxes and a label on my page. The 2 textboxes will contain numeric values. The label text will be the product of the 2 textbox values. Is there a way to do this using JQuery so that the value can get updated when I edit the textboxes without having to do a postback?Also the textboxes may contain values with commas in it: e.g. 10,000. Is there a way I can extract the number from this so that it can be used to calculate the label value.
View 2 Replies
Feb 9, 2010
I need idea of new implementation. I have a client application which will interact with my application. My application needs to count how many slides are available in the powerpoint presentation file and it needs to provide it to the end user. And also user can ask this application to provide only first two slides or 3 and 4th slides to retrieve from the PPT file. How do I approach this. If any one has answer and source code please provide it.
View 4 Replies
Feb 1, 2011
I am selecting multiple dates from a calendar control and inserting them into DB. The question: how can i make calculate number of dates selected and show the number in a textbox , using a button click event?
One other thing, in another case, i am selecting (fromdate) from Calendar1 and (todate) from Calendar2 ,, i want to calculate number of days including both dates and show the number in a textbox?
View 16 Replies
Jan 30, 2013
I need to deduct the amount for the given percentage but i am having small difference in the calculatiion
I do the following
int input = 6065;
int result = input * 60/100;
The result i got is 3657. But the actual result is 3657.6 and i need to round up so i need to get
3658.
View 1 Replies
Jul 2, 2012
How to calculate number of sundays in a year in asp.net 2.0?
View 1 Replies
Jan 20, 2011
I am using a drop down lists for selecting the month and year in .aspx page. I have to get last date of the selected month of particular selected year in .aspx.cs page. (some months have 30 days and some have 31 days)
View 2 Replies
Jun 16, 2015
How to construct a code in vb.net on how to Calculate Number Of Days Between DateNow minus given date In VB.NET ...
View 1 Replies
Dec 12, 2013
How to calculate input values by each row in gridview ?
Example input quantity is 10, then generate the serial number for each row quantity is 1
Actual expect result
View 1 Replies
Aug 26, 2010
i want to count number of saturdays and sundays in a selected month.
View 2 Replies
Apr 29, 2010
We have a web part on which we display some data in a grid. We are exporting grid's underlying datatable to Excel and displaying Open - Save - Cancel dialouge box on click of a server side button.Following is the code we are executing on click of server side button.
this.Page.Response.Clear();
this.Page.Response.AppendHeader("Content-Disposition", "attachment; filename=MyTasks.xls");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.Response.Write("...here goes my well formated html....");
this.Page.Response.End();
Problem is that when i click on Cancel in the diaglouge box then dialogue box to Open/Save excel disappears but all the server side buttons placed on my web part becomes non responsive, on click of any of those buttons their server side click event does not get fired
View 1 Replies
May 6, 2010
We have a web part on which we display some data in a grid. We are exporting grid's underlying datatable to Excel and displaying Open - Save - Cancel dialouge box on click of a server side button.Following is the code we are executing on click of server side button.
[Code]....
Problem is that when i click on Cancel in the diaglouge box then dialogue box to Open/Save excel disappears but all the server side buttons placed on my web part becomes non responsive, on click of any of those buttons their server side click event does not get fired !!!
View 1 Replies
Sep 6, 2010
I am designing a validation form which has a textfiled for inserting Employee ID and a submit button for parsing inserted value. On clicking that button the SubmitButton_Click() validate the inserted value against SQL Server database. The database has a table name EMPLOYEE containing ID and Name of employees. Now I have designed the .aspx page but stuck in the rest of the job.
View 6 Replies
Sep 2, 2010
i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday).I want result in percentage.result like this
Consistency Days of assignment Across 4 weeks 3 weeks 2weeks
0 2% 0% 0%
1 98% 100% 100%
2 0% 0% 0%
Here 0,1,2 are macthing days off.Across 98% of employees getting 1 days matching in off i.e 98% of employee might off in sunday.For this we need calculate matching days off for all the days from sunday to saturday across 4,3 2 weeks Here 98% of employees getting off in same day.0 indicates 0 days,1 is 1days and 2 is 2 days(for example 50 percentage of people will get off in saturday and sunday)
View 27 Replies
Oct 15, 2010
query to find the 5th highest salary from an employee table?
View 2 Replies
