This isn't going to work because it's going to generate the Top 10 for all records, I need the Top 10 for each ID. I think Jeff's solution may work,...

I need all the data, for instance a docid may have 74 records but I need only the top 10

Hope this is easier...

For each DOCID...

select top 10

x.DocID,o.OPTY_ID, o.OPPTY_NAME, o.SUM_WIN_PROB, o.COMMIT_FLAG,

isnull(p.TOT_MRV,...

Thanks Lowell!

I am the admin though and I can't schedule these reports either. I am able to schedule any reports I build in .Net though no problem

Another user with the same problem!

Another user with the same problem!

Sorry, good question. The next Sunday

So if I was to pass in todays date I would get 11/23/08

Do Ipossibly need some form of cursor here to produce a SQL statement

Thanks but there are many more fields that I would rather not pull into a union all.

Matt, you are a life saver! Was beating my head over it. Was the first time ever used Pivot and had copied the code from an "Expert" site. Thanks!

Can this be accomplished in any sort of cursor?

What do you mean by concatenate on the server???

The Comment field in the existing table is VarChar(2000).

I have tried this over and over and can't find my error, any help would be appreciated

This is the result I get................................

BidId(no column name)(no column name)(no column name)(no column name)(no column name)(no column name)

518CancelledIn ProgressLossNewNo BidReferred Out

527CancelledIn ProgressLossNewNo BidReferred Out

537CancelledIn ProgressLossNewNo BidReferred Out

540CancelledIn ProgressLossNewNo BidReferred Out

559CancelledIn...