Nice 🙂

Laying out the table structures and the insert statements has encouraged you to do almost all of the work.

You could answer question 1 like this:

-- problem 1 "...

Two different solutions.

-- query 1

SELECT o.id, o.first, o.last, o.person_id, o.id_master

FROM (

SELECT d.id, d.first, d.last, d.person_id, d.id_master,

x = COUNT(*) OVER (PARTITION BY d.person_id)

FROM #duplicates d

INNER JOIN #blacklist...

Please provide scripts to create all three tables and populate the source table with data.

CREATE TABLE ##a(id int identity(0,2))

INSERT INTO ##a DEFAULT VALUES

INSERT INTO ##a DEFAULT VALUES

INSERT INTO ##a DEFAULT VALUES

INSERT INTO ##a DEFAULT VALUES

SELECT * FROM ##a

Lol!

Shame the...

The sample data is a little late but never mind - what are the column names?

Unlikely as OP has been a forum member for over two years.

DROP TABLE #test

CREATE TABLE #test

(

IdX INT,

IdY INT,

...

DROP TABLE #Table

CREATE TABLE #Table (A INTEGER)

INSERT INTO #Table (A)

SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4

SELECT *

FROM #Table

ORDER BY

CASE

WHEN A...

skcadavre (6/8/2010)

---

Anyone understand what is being asked here? I've spent as long as I want to trying to figure out what he actually wants. We now have sample data...

GilaMonster (6/8/2010)

---

In some parts...

If you have to aggregate your results, and I'm sure you do given the number of rows you're processing, then GROUP BY is almost certainly the fastest way to do...

Hand or friction powered aquatic beetle?

Gopi Muluka (6/8/2010)

---

CHECK THIS

DECLARE @Table1 TABLE (ID INT , Employee VARCHAR(50))

DECLARE @Table2 TABLE (SourceFieldChar CHAR(1),Val CHAR(1) )

INSERT INTO @Table1

SELECT 1,'Ritesh' UNION ALL

SELECT 2, 'Bhatt'

INSERT INTO @Table2

SELECT 'R','X' UNION ALL

SELECT 'i',...

The best way? Impossible to tell from what you've provided. Which output columns do you want, and from which tables? Build a SELECT...FROM...with a modest restriction and test it. Look...