Member Avatar for Lethugs 
    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
  • 2 Contributors
  • 2 Replies
  • 366 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Lethugs

anybody can help pllllssssssssss

Member Avatar for Dani

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.