sql store proc

 CREATE PROCEDURE dbo.StudentAttendenceReport 'daily'

    @daytype nvarchar(20)

  

AS

  

  IF @daytype ='weekly'

    BEGIN

      SELECT * FROM [dbo].[Tbl_Daily_Attendance]

WHERE ADate BETWEEN DATEADD(d,-7,

CONVERT(nvarchar(10),GETDATE(),101)) 

AND CONVERT(nvarchar(10),GETDATE(),101)

    END

  IF @daytype ='daily'

    BEGIN

SELECT*  FROM [dbo].[Tbl_Daily_Attendance]

WHERE ADate = CONVERT(nvarchar(10),

GETDATE(),101);

END

  IF @daytype ='monthly'

    BEGIN

SELECT * FROM [dbo].[Tbl_Daily_Attendance]

WHERE ADate BETWEEN DATEADD(d,-30,

CONVERT(nvarchar(10),GETDATE(),101)) 

AND CONVERT(nvarchar(10),GETDATE(),101)

END