What is a derived table?

0 Answers  

---

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 is 1nf normalization form?

0 Answers  

---

What is partitioned view?

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

What is the difference between ddl and dml?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

What is MSDE?

2 Answers  

---

Why use “in” clause in sql server?

0 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---