How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

What is update locks?

0 Answers  

---

What stored by the master?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

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

0 Answers   Microsoft,

---

Explain what is the use of custom fields in report?

0 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---