There is, but....

It's possible to do it 'on the fly' in a select, but this has serious performance considerations once the underlying data is more than just tiny.

Another easy workaround...

That is so very true.

It always depends and nothing is perfect.

/Kenneth

And my car is faster than yours

But seriously - no product wars please.

The point that I'm trying to make is this...

No, you cannot...

>In Java is it posible to capture the errors until a return >arrive. The problem is that the trigger, when raise the >error 547 make a return and my custom...

Your only safe bet to trap all errors sent from SQL Server, is to trap them at the calling client.

You cannot trap all errors in Transact SQL.

The only place all...

You have two major performance killers in this query.

in the outer query:

and sys_nam like '%odsbeta%'

By using a leading wildcard like this, you are effectively forcing a table scan on table...

Just to sum up myself on the excercise - in order to return all 1's for you to sum and count - do like this:

WHEN column < 0.1 THEN 0.1...

This have to do with how CASE works.

One thing is that a CASE can only return one datatype - which one if there are multiple datatypes within the same CASE...

Best place to start is to search in BOL for 'clustering'.

Lots of good reading there - BOL is always a good place to start.

/Kenneth

If 'retired' means deleted and you have to set up a fresh account for the servers (ie new SID and all), I believe that your safest bet would be to;

drop...

I would also reccomend not to use the month-name style for the arguments. For it to be parsed correctly at all times, it's dependant on external settings and language.

(ie if...

ISNUMERIC returns 1 for all valid 'numeric chars'

ie - not just 0-9, but operators and punctuations as well.

(I believe everything that money can handle)

Sometimes this is not wanted, we just...

See if this applies to your situation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;268481

/Kenneth

Verify that you have the same versions of ODBC and BCP on both the test and prod server.

On the failing server, also try to exec bcp -v to find out...

All programs started through xp_cmdshell are run out of process from SQL Server.

You can think of it as a Transact SQL DOS-box if you will.

The good thing is that if...