Comments by Leila Toumi (Top 19 by date)

thanks for your reply but it gives me wrong value !!

Thanks a lot j snooze :) it works successfully :)

thanks mathi for your reply, can you give me an example please ?

Thanks for your reply, I eliminate the second + but i get the same error !!
the query: MAX( cast(whour as char(4))+':'++cast(wMinute as varchar(2))+':'++cast(wSecond as varchar(2)) ) works successfully but when i put it in the Pivot it gives me the previous error !! any idea please?

it's not the same question !!

please what if I want to display data from 2 tables (Emp_Attendance and Emp_permissionrequest), i try this sql request but i get a wrong result:

WITH per As
(
SELECT
Emp_PermissionsRequest.EmployeeID,
Emp_Attendance.EmpID,
CAST(Emp_PermissionsRequest._Date As date) As DatePermission,
CAST(Emp_Attendance._Date As date) As DateAttendance,

Emp_PermissionsRequest.StartTime,
Emp_PermissionsRequest.EndTime,
Emp_Attendance.times_IN,
Emp_Attendance.Times_Out,
ROW_NUMBER() OVER (PARTITION BY Emp_PermissionsRequest.EmployeeID, CAST(Emp_PermissionsRequest._Date As date) ORDER BY StartTime) As RNI,
ROW_NUMBER() OVER (PARTITION BY Emp_PermissionsRequest.EmployeeID, CAST(Emp_PermissionsRequest._Date As date) ORDER BY EndTime DESC) As RNO,
ROW_NUMBER() OVER (PARTITION BY Emp_Attendance.EmpID, CAST(Emp_Attendance._Date As date) ORDER BY Times_In) As RNIn,
ROW_NUMBER() OVER (PARTITION BY Emp_Attendance.EmpID, CAST(Emp_Attendance._Date As date) ORDER BY Times_Out DESC) As RNOut
FROM

MST_Employee
inner join Emp_Attendance on Emp_Attendance.EmpID=MST_Employee.ID
inner join Emp_PermissionsRequest on Emp_PermissionsRequest.EmployeeID=MST_Employee.ID

-- dbo.Emp_PermissionsRequest
WHERE
Month(Emp_Attendance._Date) = 6
And
EmployeeID = 35
)
SELECT
EmployeeID,--DateAttendance,
DatePermission,
Max(CASE WHEN RNI = 1 THEN StartTime ELSE Null END) As FirstStartTime,
Max(CASE WHEN RNI = 2 THEN StartTime ELSE Null END) As SecondStartTime,
Max(CASE WHEN RNI = 3 THEN StartTime ELSE Null END) As ThirdStartTime,
Max(CASE WHEN RNI = 4 THEN StartTime ELSE Null END) As LastStartTime,

Max(CASE WHEN RNO = 4 THEN EndTime ELSE Null END) As FirstEndTime,
Max(CASE WHEN RNO = 3 THEN EndTime ELSE Null END) As SeconEndTime,
Max(CASE WHEN RNO = 2 THEN EndTime ELSE Null END) As ThirdEndTime,
Max(CASE WHEN RNO = 1 THEN EndTime ELSE Null END) As LastEndTime,

Max(CASE WHEN RNIn = 1 THEN Times_IN ELSE Null END) As FirstTimesIn,
Max(CASE WHEN RNIn = 2 THEN Times_IN ELSE Null END) As SecondTimesIn,
Max(CASE WHEN RNIn = 3 THEN Times_IN ELSE Null END) As ThirdTimeIN,
Max(CASE WHEN RNIn = 4 THEN Times_IN ELSE Null END) As LastTimeIn,

Max(CASE WHEN RNOut = 4 THEN Times_Out ELSE Null END) As FirstEndTime,
Max(CASE WHEN RNOut = 3 THEN Times_Out ELSE Null END) As SeconEndTime,
Max(CASE WHEN RNOut = 2 THEN Times_Out ELSE Null END) As ThirdEndTime,
Max(CASE WHEN RNOut = 1 THEN Times_Out ELSE Null END) As LastEndTime

FROM
per
GROUP BY
EmployeeID,
DatePermission --DateAttendance-- ,
;

thank you very much :) it works successfully that's what I want to get :)

it works, but i need to get this list of successive dates in each date

I tried it but no result

Thanks @John C Rayan it works succesully now i just replace "DrugsValue" by "DrugsValues"

when i add my ValueMember which is "ID_Drugs" it works successfully but it insert only the list of the id, and when i add my displaymember which is "DrugsValue" i got the same error: DrugsValue is not a DataColumn or a DataRelation for the table. in my situation i need to insert the value of the checkedlistbox not the id

thanks for your reply. u tried but i got an error: DisplayMember /valueMember is not a DataColumn or a DataRelation for the table !!