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  

---

What are clustered and non-clustered index?

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

Explain about Views?

0 Answers   Infosys,

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

Explain what are magic tables in sql server?

0 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

Explain what are the events recorded in a transaction log?

0 Answers  

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---