Database

SELECT employee_leaves.leave_from, employee_leaves.leave_to FROM employee_leaves
JOIN leave_category ON leave_category.leave_category_id = employee_leaves.leave_category
GROUP BY YEAR(employee_leaves.leave_from);

Jassim Rahma wrote:

and can you rely on MySQL

Jassim Rahma wrote:

or it's better to have a process in Windows task Scheduler

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

select * from Employee where EmployeeName=N'احمد'

Set @SQLQuery = @SQLQuery + ' AND (EmployeeName LIKE N''%'+@EmployeeName +'%'') '

CREATE Procedure sp_EmployeeSelect
    @EmployeeName nvarchar(50)
AS
Declare @SQLQuery as nvarchar(2000)

SET @SQLQuery = N'SELECT * from Employee Where (1=1)'
If @EmployeeName <> ''
    Set @SQLQuery = @SQLQuery + N' AND (EmployeeName LIKE N''%'' + @EmployeeName + N''%'')'

Exec sp_executesql @SQLQuery,
    N'@EmployeeName nvarchar(50)',
    @EmployeeName

CREATE Procedure sp_EmployeeSelect
    @EmployeeName nvarchar(50)
AS
    SELECT
        *
    FROM
        Employee
    WHERE
        @EmployeeName = N''
    Or
        EmployeeName Like N'%' + @EmployeeName + N'%'

SELECT TOP 10000 *
FROM Staging.[dbo].AD
WHERE DATE_CREATED BETWEEN '02/09/2014 05:00:00' and '03/09/2014 05:00:00'