I also belive in multiple triggers. I have one trigger for auditing, plus additional triggers (often more than 1) for other purposes. I find it is easier to manage the...

When I follow the instructions in the question, I get nothing!! The only popup that displays is when I press the right mouse button, and it contains nothing related to...

I used the data from the original question, and got an index scan for all 4 queries (running sql 2000),

Mal

Another way of getting a select query quickly using Query Analyzer is also to use the Object browser window on the left, right click on a table name, and select...

The following will work for you:

SELECT Departments.DeptName, Inventory.TypeCode,

        SUM(Sold) AS NumberOfItemsSold,

        SUM(Bought) as NumberOfItemsBought,

  Case Inventory.TypeCode

   When 'AB' then SUM(Sold) 

   Else 0

  End AS ABItemsSold

FROM Inventory INNER JOIN

        Departments ON Inventory.DeptID = Departments.DeptID

GROUP BY...

Thanks for your offer Amit. However we found another copy of the mdf file that we could use and were able to move forward.