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,

---

What do we have to check in database testing?

0 Answers  

---

What are scalar functions in sql?

0 Answers  

---

What does indexation mean?

0 Answers  

---

Does index slows down insert statements?

0 Answers  

---

---

Explain what is the function of sql server agent windows service?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

Can you use order by when defining a view?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

How the data stores in a page?

1 Answers  

---