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
- 2033 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are the authentication modes in sql server?
How to return the second 5 rows in ms sql server?
How to loop through result set objects using odbc_fetch_row()?
can you any body tell me which service pack is installed in the sql server?
How to delete the duplicate rows from a table in SQL Server ??
what are database files and filegroups? : Sql server database administration
What is the sql profiler?
how will add additional conditions in sql?
0 Answers Amdocs, Apps Associates,
What is the difference between cross join and Full outer join?
what types of replication are supported in sql server? : Sql server database administration
How to create a view on an existing table in ms sql server?
How to create a Master database in 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)
