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
what changed between the previous version of sql server and the current version? : Sql server database administration
I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.
Difference between uniqe index and uniqe constraint?
how to know description of a table in sqlserver 2000
How to change the name of a database user?
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
What is Cross Join
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
How do I create a stored procedure in dbml?
How to view existing indexes on an given table using sp_help?
What are sp_configure commands and set commands?
What is the significance of master, tempdb and model databases?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)