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 command is used to create a table by copying the structure of another table?

7 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

What options are available to audit login activity? : sql server security

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

What are functions in the sql server?

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

What is sql server programming?

0 Answers  

---

how can a database be repaired? : Sql server administration

0 Answers  

---