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,

---

How to concatenate two character strings together?

0 Answers  

---

Should you normalize audio?

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

What is buffer cash in sql server?

0 Answers  

---

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

What is merge?

0 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

which table keeps the locking information? : Sql server administration

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---