This works for me...

declare @stores table (stor_name varchar(10))

insert @stores

select 'Simon'

union all select 'Simon'

union all select 'Simon'

union all select 'Simon'

union all...

4 + 3 +...

If you're not using SQL 2005, I guess you could simulate ROW_NUMBER like this...

declare @param varchar(8000)

set...

David (5/7/2008)

---

Thanks for the link to the article, I've not used either PIVOT or UNPIVOT before so I'm impressed with how easy it is to use. However, my query contains...

Who's Jeff?

Here's an article from the other day with some examples...

http://weblogs.sqlteam.com/jeffs/archive/2008/04/23/unpivot.aspx

UNPIVOT or UNION ALL might be more useful 🙂

There are examples in BOL...

Just like any other...

Nice work, Jeff. That plural table name must've been difficult for you to come to terms with 😀

No matter. Something like this...

declare @tblcustomeraudit table (customerid int, forename varchar(20), surname varchar(20))

insert @tblcustomeraudit

select 1, 'John', 'Smith'

union all select 1,...

Is there a primary key or unique row identifier for the table?

This all looks fine to me.

Are there any lines like the following which don't contain an aggregation (like COUNT)?

SET @Completed_Null_Urgency_INT = (SELECT COUNT(Order_Code) AS Count_INT

The error...

Laziness is the mother of invention :w00t:

I agree with Michael. This is the example I knocked up, but I was waiting for a reply. I also wanted to know if 'pairs' could have one of them...

So what would be an example of the user inputs? Several pairs of product name and product type (potentially)?