Re: [SQL] left outer join on more than 2 tables?

2009-06-17 Thread Carol Cheung
On 16/06/2009 19:12, Rob Sargent wrote the following: Richard Broersma wrote: On Tue, Jun 16, 2009 at 2:40 PM, Rob Sargent wrote: Is there a city without a reference to region? I don't know, but the OP wanted to know complaints by region. I didn't try this, but with regionless

Re: [SQL] left outer join on more than 2 tables? (UNCLASSIFIED)

2009-06-17 Thread Hall, Crystal M CTR DISA JITC
Classification: UNCLASSIFIED Caveats: NONE My problem with that is that you are counting rows per region and you have done a left jion on region. That means there will be at least one row per region even if there are 0 compliants. It might yield the same result now, but if you even have a p

[SQL] Trapping statement timeout

2009-06-17 Thread Kevin Duffy
Hello All: I certain that for you guys that this will be trivial. What I need to do is to trap, go into an exception block, when a statement times out. Let me explain. I have a processing that creates summary records based upon records in another table. Think in terms of summary sa