show monthly attendance of an employee based on month

Question

Deepak Saini · Answer

Dear susanta your make your condition according your requirement . if you would not wont to display with the dateyou make condition according your month.hide date according to month. pic the month and calculate the no of days in this month.display data according to this make if else condition....

Susanta Rout · Answer

if the month is 28 days then.. my requirement is not to show293031 in a gridview header

Susanta Rout · Answer

if the month is 28 days then.. my requirement is not to show293031 in a gridview header

Susanta Rout · Answer

if the month is 28 days then.. my requirement is not to show293031 in a gridview header

Susanta Rout · Answer

if the month is 28 days then.. my requirement is not to show293031 in a gridview header

Deepak Saini · Answer

Dear Susanta your make diff between in time and out time and pass the diff in a function  compare this diff and return p plAHD according to this diff in function CREATE FUNCTION GetAttendanceType ( @DifferenceValue nvarchar ( 15 )) RETURNS varchar ( 30 ) AS BEGIN declare @Return varchar ( 30 ) select @return = case @ DifferenceValue if( @ DifferenceValue>=420) begin @Return ='P' end else( @ DifferenceValue @ DifferenceValue>=360 ) begin @Return ='P' end else( @ DifferenceValue 360 && @ DifferenceValue>=210 ) begin @Return ='HD' end else begin @Return ='A' end end return @return end --totalmin(intime -Outime ) select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=1 and month=09 and year=2015 select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=2 and month=09 and year=2015 select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=3 and month=09 and year=2015 select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=4 and month=09 and year=2015 select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=5 and month=09 and year=2015 ........................................ select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=30 and month=09 and year=2015 select GetAttendanceType (totalmin) as Totalmin from AttendanceMst where day=31 and month=09 and year=2015 where dept=22 i hope that you can easily solve your problem

Susanta Rout · Answer

to show is a gridview dymamically with date of months

Susanta Rout · Answer

to show in a gridview

Francis · Answer

What is your exact problem here?