What is the difference between row_number and dense_rank?

0 Answers  

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

How is foreign key related to primary key?

0 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

---

What is filtered index?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

Why we need sql server?

0 Answers  

---

What is scalar user-defined function?

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

how to find out the repeated value from table using groupby function?

4 Answers  

---