What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

syntax and example for bitmap index in sql???

1 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,

---

How to get the definition of a trigger back?

0 Answers  

---

Explain nested trigger in sql?

0 Answers  

---

---

Explain indexing and what are the advantages of it?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

What are distributed partitioned views?

0 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---