Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Angry Unanswered: Pb with Quey .....

    Hi,
    I have this table :
    T1(myDate datetime,product varchar(200),nbItem int)

    I would like to know for 3 specifics months the total number(sum) of item for each products but in one query .... All my try give me a big number


    The result look like :

    Product Month1 Month2 Month3
    XXXXXX 12 14 14
    YYYYYYY 21 23 34
    ZZZZZZ 123 156 2342

    In fact is a pivot table problem ...
    if any one have a solution ... with out temporary table....
    thanks ...
    Last edited by benmikee; 03-02-03 at 12:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •