-
pivot with some flexibility?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|