Jason,

Had a thought: Union?

SELECT A.Name, A.ID, B.Name

FROM #temp1 A

JOIN #temp1 B

ON A.ID = B.ID

AND A.Name > B.Name

UNION

SELECT Name, ID, Name

FROM #temp1

GROUP BY Name, ID

HAVING COUNT(*) > 1

Jason,

Sorry, busy day, I missed that. For 2K, my first thought is to use either a table variable or temp table with an identity. Definitely not the most efficient nor...

Is it empty, or does it say "NULL" in the text file?

I don't know your webservice, but a parameter needs to be of a specific type when sent to a stored procedure. The only way to send a null (that I...

Okay... that might be what I missed. Wouldn't a simple CTE solve that? And if you wanted only a distinct "John - Jane" add a distinct keyword?

create table #temp1

(

...

In my solution I show 3 names for ID 5.

jcrawf02

Then I am missing the intent. This lists every unique combination only once.

create table #temp1

(

name varchar(10),

ID int

)

insert...

Okay, I may be under-thinking this, or I may just be to lazy, but wouldn't this work?:

create table #temp1

(

name varchar(10),

ID ...

Personally, I like the Case method better. The execution plan is the same as for the CTE, but to me it is easier to see what is going on.

select CASE...

I have to agree with Steve. Keep your eyes out for short term contracts. You can build up your network of potential customers while getting a somewhat stable income. If...

Doesn't really matter as far as difficulty. What you need to be concerned with is performance. My guess (in other words check for yourself) is that given as small as...

If you use a stored procedure instead it will send the parameter as a delimited string. You can then parse the string in TSQL (into a temp table, for example)...

Dave (4/24/2009)

---

Not to belabor the point, but there are some things in some situations that it is impossible...

Dave (4/23/2009)

---

Timothy J Hartford (4/23/2009)

---

"Please consider attached resume for posted position.

Not only that, but I believe that this individual, by replying with HELPFUL CRITICISM instead of sarcasm, with all...

"Please consider attached resume for posted position.

Also, I would like to draw your attention to what I feel are sever deficiencies with regards to your resume submission web app....