ALTER procedure [dbo].[uspLeaveDetails](@User varchar(15),@FromDate datetime,@ToDate datetime)
AS
BEGIN
Select FromDate,ToDate,
NoOfDays,FirstName from UserDetails,LeaveDetails
where FromDate > =@FromDate AND ToDate <=@ToDate AND
UserDetails.USerID=@User
End