Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2181 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Why variables called the most powerful component of ssis?
Explain few of the new features of sql server 2008 management studio
What are commonly used odbc functions in php?
Give me any three differences between Truncate and Delete.
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
how to delete duplicate rows in sql server2005
7 Answers Cisco, CTS, HCL, IBM,
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How can sql server instances be hidden?
What is the advantage of sql server?
What is a cursor, index in sql?
What are the basic functions for master, msdb, model, tempdb databases?
How connect excel to sql server?
-
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)
