Yes, exactly so - it's a table coming from an external source.

I've ended up using syscolumns, which creates no problem accessing it.

Thank you!

Thank you!

The table with 'fee' columns is on SQL2000.

I'm going to have to execute my script from SQL2005.

When I refer information_schema.columns from the 2000 server, it works fine.

When I try running...

Steve,

Unfortunately, I cannot do anything about the database design here.

Yes, these are all different types of fees and they each are supplied with 'feetype' columns.

I've tried information_schema.columns before, it didn't...

Thank you!

This helped a lot!

Now, I have another task to do - I need to summarize values of all the 'fee' fields for each row.

Now there three 'fee' fields, but...

Thank you!

Thank you!

It helped a lot!

Sorry, I forgot to add one more field.

I need a row value field mixed with the aggregate on the selects.

That's why it's problematic to use GROUP BY (and HAVING for...

I edited the post, thank you!

Thank you again, John!

I'll test it tomorrow at work.

Thank you!

I'll try this one, too.

But I wonder if CTE is SQL 2000 compatible. My database is on a SQL 2000 server.

Already looking!

Thank you! 🙂

Hi Steve!

You are right - I do sound confusing and I'm sorry about that. :blush:

Three or five - doesn't matter. Let's make it three.

It's sampling data with no particular criteria.

Let's...

Ken,

What I need is the minimum order_id for each buyer and five items for each of the orders.

The result should look something like this:

Buyer_id order_id ...