Hi, I have 3 tables Description, Item, Transaction

            Description                 Item                Transaction
          DeID       Name      IID        Name     DeID     TranNo   Type     IID    Date
            1       Printer      1   Stylus T10      1         1     Repair    1
            2       Monitor      2          HP       1          2    Repair    3
                                 3       ViewSonic   2

    I need to count how many printers, Monitors etc. are in Item and how many are under repair

    eg.

    there are 2 printers in item, and 1 under repair

    output should be:

              Description           count              under repair
                Printer               2                      1
                Monitor               1                      1

    Im using vb.net 2010 and sql server 2008 r2
    as much as possible not using stored proc

    Thanks for your help

anybody can help pllllssssssssss

It's showing you marked this question solved. Were you able to solve this?