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
- 2216 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of DBCC commands?
What are different types of replication in sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain important index characteristics?
What is the use of RDBMS?
How to find index size for each index on table?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Name three of the features managed by the surface area configuration tool? : sql server security
Can we perform backup restore operation on tempdb? : sql server database administration
What is the difference function and stored procedure?
What is indexed view?
Explain go command 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)
