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  

---

Explain the steps needed to create a scheduled job?

0 Answers  

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

---

Explain time data type in sal server 2008?

0 Answers  

---

What are the types of constraints?

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  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

Explain tablesample?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

What are the elements of dbms?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---