I have a table Events
Events containing
cardno,time,id,name--each id has a cardno
my requirement is every day each employee swipe the card
several times
i want to calculate first and last time of each card
the output should be
name 1 2
6 7
in out in out
holiday holiday
xxx 09:30 06:30 09:40 06:45
where 1,2...... are dates for example january 1,2, etc. 6
and 7 are saturday and sunday
how it is posssible
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is lock escalation?
How can you list all the columns in a database?
Explain the difference between delete,drop and truncate in SQL Server?
How can I know what locks are running on which resource?
How to rebuild master databse?
What is a View ? Can we insert, Update and delete a view?
How do you make a trace?
What are the different authentication modes in sql server?
how to delete duplicate rows from table
What types of integrity are enforced by a foreign-key constraint
Can a function call a stored procedure in sql server?
How to copy the tables, schema and views from one sql server to another?