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 page splits? : SQL Server Architecture

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

Can we call stored procedure in trigger?

0 Answers  

---

How to list all stored procedures in the current database using ms sql server?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

What is a Join and explain its types?

0 Answers  

---