date conversion and select subquery

See more:

SQL-Server

SQL-Server-2008

alter PROCEDURE Sp_GetDetailsLeaves_PaySlip
(
@empid varchar(15),
@fromdate date,
@todate date
)
AS
BEGIN

Declare @tot int
Declare @pd int
Declare @Lt int
Declare @Ab int

set @tot =(SELECT SUM(othrs) as totothrs FROM Tbl_Daily_Attendence where emp_id = @empid and cdate between @fromdate and @todate )

set @Lt =( SELECT COUNT(cdate) as Leavestaken FROM Tbl_Daily_Attendence where emp_id='@empid' and cdate between '@fromdate' and '@todate' and attendencetype ='L')

set @Ab =( SELECT COUNT(cdate) as Leavestaken FROM Tbl_Daily_Attendence where emp_id='@empid' and cdate between '@fromdate' and '@todate' and attendencetype ='A')

Declare @sql varchar(250)
select @sql = (select distinct @tot as Othrs,@pd as Presentdays ,@Lt as Leavetaken,@Ab as Absents from Tbl_Daily_Attendence)

Exec(@sql)

print @sql
END