Please provide table structure and sample data as described in the first link in my signature.

Since we don't know the structure of your table, one answer might be:

SELECT [columns] FROM...

From the limited information that's available:

From my point of view the vendor is right with his advice since otherwise any change on a source table would affect your querys .

However,...

Based on the information provided my answer is "maybe".

Adding some more info to your post the answer might turn into "it depends".

Assuming enough information provided for xsd structure and desired...

You might want read the following article:

http://www.sqlservercentral.com/articles/Schemas%2fDTDs/3118/

Note: Based on context I assume it's homework or something similar.

Therefore, I didn't post the answer right away, since -back to the old days...

Please read and follow the first link in my signature on how to post sample data.

The way the question is described doesn't really help to answer easily.

Maybe Dynamic Cross Tab...

The aggregation used within the PIVOT clause is either to eliminate NULL values (e.g. MAX clause) or to SUM or COUNT the actaul number of rows.

You'll still get all your...

The nodes structure you provided as expected result is incomplete. You have 4 unclosed nodes.

This is really hard to notice since you're using the same name ("item") to describe at...

I usually try to figure out if the request is because that person can't do it by himself/herself and it's not part of the general job that person is responsible...

Triple post.

Please start discussion here

Note: duplicating a thread after just 10 minutes, then yet another one after just two more minutes probably is even less a good way...

duplicate post.

Please start discussion here

Note: duplicating a thread after just 10 minutes probably is not the best way to get an answer...

First: Glad to hear that Ryans solution...

untested, but it should work:

;WITH cte AS

(

SELECT ID, CODE FROM MyTable GROUP BY ID, CODE

)

SELECT ID, COUNT(*) AS CNT

FROM CTE

GROUP BY ID

HAVING COUNT(*) > 1

Please follow the first link in my signature on how to provide sample data.

I guess one of the reason that you don't have an answer yet are the missing table...

I tried to run your query but stopped it after 3 minutes or so.

So, yes, I can confirm that it takes forever...

Then I just tried the sample code Ryan Randall...

parthi-1705 (12/2/2009)

Try this

...

It is not coming in MIN ,MAX

Since this is not in the Table i can able to enter so CAN should Return But Yours...