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  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

---

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

What are xml indexes?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

What are various limitations of the views?

0 Answers  

---