Comments by Danuuu - CodeProject

Danuuu 19-Feb-17 9:07am View

am not getting how to do?And the example is for Current DateTime and i need to store specific time

Danuuu 19-Feb-17 6:48am View

Thank you but example is of DateTime and I need to store only TIME how to convert only Time to mysqltime

Danuuu 19-Feb-17 2:35am View

Okay i will change table name but I haven't got any errors but time coloumn values are 00:00:00

Danuuu 19-Feb-17 2:13am View

Datatype is Time.And Table name is user

Danuuu 13-Jun-14 2:21am View

SELECT CASE
WHEN (SELECT COUNT(*) FROM dbo.tempDeviceLogs
WHERE CONVERT(VARCHAR,tempDeviceLogs.logDateTime,101) = CONVERT(VARCHAR,GETDATE() - 31 ,101)
AND Device_Person_id = personal_id) > 0 THEN 'P' ELSE 'A' END as Emp_Status FROM Emp_setting

this code is executing showing only one column i.e emp_status
how to add device_person_id,personal_id,department,designation columns to this code only

Danuuu 13-Jun-14 1:23am View

Invalid object name 'Emp_setting'.

Danuuu 12-Jun-14 8:38am View

ya that query is not working

Danuuu 12-Jun-14 8:19am View

i didnt got your question

Danuuu 12-Jun-14 8:08am View

using left inner join if logdatetime is set to null then emp_attendance will show null na
i dont have clear idea about inner joins if possible help me

Danuuu 12-Jun-14 8:01am View

can this one be solved with inner join any idea??

Danuuu 12-Jun-14 3:59am View

Do you know any other method for getting solution

Danuuu 12-Jun-14 3:42am View

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

Danuuu 12-Jun-14 3:19am View

Invalid object name 'tempDeviceLogs_1'.

Danuuu 12-Jun-14 2:23am View

same error

Danuuu 12-Jun-14 1:47am View

Select Device_Person_id,personal_id,Date1,(
cASE WHEN eXISTS(
sELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime
) then 'P' Else 'A' End )as Status
FROM
(
Select Device_Person_id,personal_id,Cast(logDateTime as DATE)AS DATE1 from Emp_setting a,(Select Distinct logDateTime from tempDeviceLogs) b
) T

SHOWING ERROR
Invalid column name 'Device_Person_id'.

Danuuu 11-Jun-14 8:18am View

i need to use columns from dbo.tempdevicelogs and dbo.persons_profile it means in result

logsid deviceperson_id device_id logdatetime inout department designation etc
all columns should be there
these all columns i mentioned in above code

Danuuu 11-Jun-14 7:52am View

i got answer by updating so

Danuuu 11-Jun-14 6:42am View

i have posted a new query there i posted 3 columns please check it

Danuuu 11-Jun-14 6:40am View

without updating using 3 tables i have to show employee attendance

Danuuu 11-Jun-14 4:42am View

sorry now it's working this answer was helpful and correct for this question.
But i have to do this without updating emp_status

Danuuu 11-Jun-14 3:59am View

thank you so much for your help.But still it's showing absent

Danuuu 11-Jun-14 3:23am View

how to minus? i dnt no
GETDATE(2014-06-11) Is it correct?

Danuuu 11-Jun-14 2:59am View

logDateTime
2014-05-11 08:09:15.000
2014-05-11 08:12:32.000
2014-05-11 08:15:01.000
2014-05-11 08:15:05.000
2014-05-11 08:18:13.000
2014-05-11 08:18:57.000
2014-05-11 08:20:06.000
2014-05-11 08:20:18.000
2014-05-11 08:20:22.000

Danuuu 11-Jun-14 2:43am View

ya am also having same field

Danuuu 11-Jun-14 2:31am View

logdatetime is datetime format only

Danuuu 11-Jun-14 2:14am View

in dbo.tempDeviceLogs datetime field is there "logDateTime"

if there is any entry for logdatetime then employee status should be "present" else "absent"

Comments by Danuuu (Top 26 by date)