15,867,870 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 Amaan23 (Top 30 by date)
Amaan23
18-Jul-14 3:32am
View
Thanks, this is something new which i was not aware. Let me check and try out.
Still have doubts on above as my table(Time Attendance Table In and Out info) will have approx 50 events getting inserted in table in 2 min.
Well lets see. Thank you for your help.
Amaan23
27-Jun-14 5:54am
View
Thanks,
Initially i have used ' GRANT select on' Command but for some strange reason SQL server was playing hide and seek.
After executing this command i logged in with that user i was able to access all the tables..so i thought i was making some mistake.... later when i discuss with my friend. He advice to log off close SQL server management and then log in with new user and check................. and it worked fine...
Thanks for your help. Must appreciated.
Amaan23
23-Jun-13 9:07am
View
sorry for delayed reply, i was out of city.
I tired this but still no luck. once we have order by time, it takes lot of time to execute it.
Thank for your help
Amaan23
17-Jun-13 7:25am
View
Yes i can write Stored procedure to the database
Amaan23
15-Jun-13 14:52pm
View
Thanks for your reply.
I have no control over the table or hardware thats why i cannt use MSMQ :(
My scope is only to connect and get the newly row(event) and display it on web page. -- Live events
Thanks
Amaan23
29-Nov-12 7:37am
View
Solved !!! thanks
Amaan23
29-Nov-12 5:17am
View
any more suggestion. still struck with this :( please help
Amaan23
28-Nov-12 0:06am
View
SQL Server 2008
Amaan23
27-Nov-12 13:52pm
View
any more suggestions please
Amaan23
27-Nov-12 8:33am
View
same error
Amaan23
27-Nov-12 8:32am
View
thanks friend. but
its showing error
Msg 147, Level 15, State 1, Line 5
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
Amaan23
27-Nov-12 4:59am
View
thanks for the reply, but this will not work surely and as you said, i have tried that... it gives Error "Invalid Column name " TotalWorkTime"
Amaan23
26-Nov-12 16:09pm
View
i tried but i am not getting.
Amaan23
26-Nov-12 15:50pm
View
how ? pls reply
Amaan23
26-Nov-12 14:14pm
View
thanks Jitendra,
Both links are same and i have ready gone through this link. Thank you.
any more suggestion
Amaan23
26-Nov-12 13:17pm
View
Thanks for all the help...
Can i put some condition on TOTALWORKTIME ... such as. display only the person who has worked(TotalWorkTime) more then 12 hours... without using Pivot.
Amaan23
26-Nov-12 12:50pm
View
42 views and no reply :(
Please help me
Amaan23
4-Nov-12 15:05pm
View
Espen..
Is it working ?
why i am getting conversion failed message
Amaan23
4-Nov-12 14:18pm
View
Again Error :(
Msg 241, Level 16, State 1, Line 19
Conversion failed when converting date and/or time from character string.
Amaan23
4-Nov-12 14:15pm
View
thanks let me try it
Amaan23
4-Nov-12 13:33pm
View
did u modify it ?
now i am getting new error
Msg 241, Level 16, State 1, Line 19
Conversion failed when converting date and/or time from character string.
Amaan23
4-Nov-12 13:30pm
View
Deleted
I did more then 10 times... its not working..
P.S i am using SQL2008
Amaan23
4-Nov-12 11:47am
View
Thanks for the Help but still its not working..
the new query using pivot and Description columns gives error...
I tired a lot to solve it but :(
here's the error
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@tInFrom".
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@tOutFrom".
Amaan23
31-Oct-12 13:29pm
View
Thanks for your help.
Initially i tried this, but couldnt get it.
The output what i am getting for the above query is
FULLNAME TIMEIN TIMEOUT
ABC 10:23:00 Null
XYZ 12:35:23 Null
ABC Null 17:50:23
XYZ Null 16:58:23
How to make it as
FULLNAME TIMEIN TIMEOUT
ABC 10:23:00 17:50:23
XYZ 12:35:23 16:58:23
Amaan23
30-Oct-12 10:27am
View
FRIENDS HELP ME!!!
Amaan23
30-Oct-12 0:51am
View
emp table containing all the Employee and i have Events Table which contains all the logs generated from the hardware device. ( relation between them EMP inner join EVENTS on EVENTS.EMPID = EMP.ID). events are stored with date and time.
Amaan23
29-Oct-12 13:41pm
View
Help me friends
Amaan23
29-Oct-12 6:12am
View
i thought this is the best way, if their is another way, please help me out.
Amaan23
29-Oct-12 1:55am
View
I have work out the TOTALWORK TIME... heres what i have done.
CONVERT(VARCHAR(20),DateAdd(SS,Datediff(ss,MIN(CONVERT(varchar,Eventime,14)), max(CONVERT(varchar,Eventime,14)))%(60*60*24),0),114) AS TOTALWORKTIME
but still lunch time seems mistery to me. I am not understanding how to work out with that.
The current query gives me the Events from 00:00:01 to 23:59:59
what i want is to divide it such as
Morning Session TIMEIN as MTIMEIN and TIMEOUT as MTIMEOUT between 00:00:01 to 12:59:59
Afternoon Session TIMEIN as ATIMEIN and TIMEOUT as ATIMEOUT between 01:00:01 to 23:59:59
sorry my english is not that good.
Amaan23
29-Oct-12 1:54am
View
Format : '2012-02-26 00:00:00'
Show More