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   HCL, Wipro,

---

Explain query editor regions

0 Answers  

---

What is update locks?

0 Answers  

---

Define primary key?

0 Answers  

---

What are the different types of Indexes available in SQL Server?

0 Answers  

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

what does the automatic recovery do? : Sql server administration

0 Answers  

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---