[elgokr]

اذا لم يعمل الكود التالى معك

كود :

ALTER proc [dbo].[data_search]
@fd varchar(50),
@sd varchar(50)
As
SELECT [NAME_OF_EMPLOYEE] As 'Name Of Employee'
    ,[DAY] as 'Day'
    ,[MONTH] as 'Month'
    ,[INN] as 'In'
    ,[OUT] as 'Out'
    ,[TOTAL_HOUR] as 'Total Hour'
    ,[WORKS_DETAILS] As 'Works Details'
FROM [dbo].[EMPLOYEES]
WHERE [DAY] BETWEEN @fd AND @sd

فيمكنك ان تجعله بهذا الشكل

كود :

ALTER proc [dbo].[data_search]
@fd varchar(50),
@sd varchar(50)
As
SELECT [NAME_OF_EMPLOYEE] As 'Name Of Employee'
    ,[DAY] as 'Day'
    ,[MONTH] as 'Month'
    ,[INN] as 'In'
    ,[OUT] as 'Out'
    ,[TOTAL_HOUR] as 'Total Hour'
    ,[WORKS_DETAILS] As 'Works Details'
FROM [dbo].[EMPLOYEES]
WHERE [DAY] >= @fd AND [DAY] <= @sd

تذكر اذا كان عمود DAY من نوع تاريخ

فيجب ان تعرف كلاً من FD و SD كونهم تاريخ وليس نص

واذا كان الـ DAY من نوع نص وليس تاريخ فالكود الخاص بـ BETWEEN

لن يعمل معك لكون المحتوى نص وليس تاريخ

تحياتى لك

وتمنياتى لك التوفيق