ALTER PROCEDURE dbo.AttendenceReportSP
(
@Option int,
@compname varchar(30),
@deptname varchar(30),
@year varchar(4),
@month varchar(10)
)
AS
begin
declare @datetimestring varchar(30),@loccode varchar(30),@DateTime datetime,@years varchar(4),@months varchar(10),@ff varchar(12),@y int,@m int,@empcode int
if @option=0
begin
select @y=convert(int,@year)
if @month=convert(varchar,'January')
select @m=convert(int,'01')
else if @month=convert(varchar,'February')
select @m=convert(int,'02')
else if @month=convert(varchar,'March')
select @m=convert(int,'03')
else if @month=convert(varchar,'April')
select @m=convert(int,'04')
else if @month=convert(varchar,'May')
select @m=convert(int,'05')
else if @month=convert(varchar,'June')
select @m=convert(int,'06')
else if @month=convert(varchar,'July')
select @m=convert(int,'07')
else if @month=convert(varchar,'August')
select @m=convert(int,'08')
else if @month=convert(varchar,'September')
select @m=convert(int,'09')
else if @month=convert(varchar,'October')
select @m=convert(int,'10')
else if @month=convert(varchar,'November')
select @m=convert(int,'11')
else if @month=convert(varchar,'December')
select @m=convert(int,'12')
select @ff=PunchDate from register
select @DateTime=convert(datetime,@ff,101)
select @years=DATEPART(year,convert(datetime,@DateTime))
select @months=DATEPART(month,convert(datetime,@DateTime))
select * from registerwhere @y=@years and @m=@months
end
RETURN
end