If the insert in table 2 is inside the transaction, there is no way to keep just that ('b') from not being rollbacked, as you have described.

When you do a...

You might try to google for something like 'postgres date function' ....?

/Kenneth

Here's one way of doing it.. It's a lot of writing, but it works.

I'm assuming that it's a datetime datatype? (that's why the...

An outer join and the coalesce function on rates column should do the trick.

Basically something along these lines.

SELECT   c.company,

         s.servicename,

         COALESCE(r.customRate, s.standardRate) as 'rate'

FROM     clients c

JOIN     services s

ON      ...

Heh. I use to think it's the other way around - you ask them (the girls) something and you get an answer. When you later apply that answer they get...

Another way to list a database's all tables with the names of PK constraints:

select  table_name,

        constraint_name

from    INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

where   objectproperty( object_id( constraint_name ), 'IsPrimaryKey' ) = 1

Note that the information_schema views...

AFAIK, Transact SQL is parsed left from right, starting from the innermost parenthesis. (haven't verified it though )

About comparing truth tables... SQL is...

Actually, the real problem here is a functionality that's not particularly suited to Transact SQL. You can't do WHERE myColumn IN ( @commaseparatedstringofvalues ) just like that...

Have a...

I was merely trying to point out the fine difference between 'expected' and 'intended'... What we intend may not always be what we can expect

Actually, this is very much expected sorting behaviour.

Remember that computers never makes any assumptions, they just do what you tell them to. In...

As you might have guessed, it is a question of null handling, and one thing that sets how nulls are handled are the ANSI_NULL setting.

What you're seeing is how it's...

I'd like to add a somewhat generic opinion to the original question "Am I wrong in thinking that attaching this generic error handling to all insert/update/deletes is a waste...

As you suspect, I too am guessing that your query has some flaw and seems to calculate twice the correct value.

If you could supply example of the table(s) involved and...

Though, don't forget that the sqlserver service also needs permissions to write to that share on the client.

..this all happening over the internet..? Might not be as trivial to fashion...

This is not quite true. In addition to what Frank said, there is only one way to guarantee that rows will be returned with a specific order, and that is...