15,917,951 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Danuuu (Top 26 by date)
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"
Show More