Hi:

I enjoy to use the new 2005 operator [pivot] to transform the rows to columns with one query.

But I am wondering if there are some flexibilit(ies) there:

1. I could not put a where clause when I want to limit the
pivot result such as to limit the product category to items
with Food related only, or beverage only.
2. If I want to select 10 years summarize data, or 15 years, Do I have to type 1990, 1991, 1992.... instead of 'dynamically' give me all the year available within the row set?

In a sentence, I have to know the result first then I have to type in and finally run the query?

thanks
David