Sorry, I'm not following you...

Okay.  First off, I forgot to add the plus sign:  @InputParameter = RTRIM( LTRIM( InputParamter) + '%'

When you pass in Warner/ Cinder, do you get all of the values...

We need more information. Does you column actually contain "Warner/Cinder" or is that in multiple records?  Also, what is the code passing in your parameter?  You may actually need to...

I think we may need more information, but here is a start:

SELECT [id], COUNT( [id]), OtherFields

FROM MyTable

GROUP BY [id], OtherFields

HAVING COUNT( [id]) > 1

The site now has a snail mail address for sending in donations! 

With this group, I feel sure we can help.  This family does not need the additional stress of...

Been there as have most of us, (on many, many of my Contracts - especially Government...) and I feel for ya!!   

Oil well...

These are the kinds of business rules that are better stated up front. 

Instead of making your Revenue's > 0, try making them <> 0. 

(It sounds like I will...

I think you may have copied your query incorrectly.  First, should there be a comma after f1 in your subselect?  Also, where do the values prj.f3 and prj.f4 come from? ...

Go to Enterprise Manager under the Table icon.  Look at the tables on the right of the screen and see if they are dbo or they have a specific user...

Very nice!  Thanks Ryan - I will save this...

I have method I have worked wit help from people on this site that concatenates multiple values based upon a similar ID.  Unfortunately, I have that code at work.  Once...

Are you getting this because of multiple replies, (names, dates, etc...)?  If that is the case, you can concatenate these with a function, but it depends upon how you want...

Is this for a report or an application?  In other words, will it be used occassionally or continuously by multiple users? 

I'm thinking you may be able to try populating...

Don't know what to tell you...  It has to be a View? 

This is a poor solution and I would highly recommend you search this site for Pivot Tables, but here goes:  Clumsy Pivot Table Solution