Correct. There are some errors that will return the error to the CALLING context (i.e. the context "above" the one the commands are executing in), instead of in the...

shahm10 (7/28/2009)

---

I want the output in following format:

---------------------------------------------------

Classification | Jan AVG | Feb...

Look under the "ifCode shortcuts" while in the edit interface, and pick the [ c o d...

So - what result are you trying to get to? Are you looking to do averages over BOTH data sets (meaning - go for a UNION ALL set) or...

mike brockington (7/27/2009)

---

There is an additional issue here, which I don't think has been touched on in this thread, which is that major printing houses can abuse this system. As...

Paul White (7/26/2009)

---

Not strictly true - a CLR user-defined function can perform data access, including calling stored procedures.

The stored procedure code is subject to the...

Since the insert failed, the transaction is still committable...because there is nothing IN the transaction.

Try/Catch will catch it at a higer scope. Something like this will work:

BEGIN TRY

exec ('select * from mattserver.mytable.dbo.tablename')

end try

begin catch

print 'that is not a valid server'

end catch

you need to make sure you have the right data types coming out of the CASE. Case will try to make its best guess which data type to use,...

The only option you might have is to capture the change in something that doesn't get rolled back (a table variable for example), then apply the change all over again....

@@error is fairly limited in what it can do for you. It seems to be useful in catching informational messages, or messages that have been determined not to be...

K. Brian Kelley (7/23/2009)

---

I think the Novell volumes are only visible through the Novell client. I believe that client only works for a logged on user (not for a service...

It's an actual execution error, which means it doesn't execute anything after the initial error. Meaning - never mind the GOTO's, it's going nowhere after the error.

This is precisely...

Carl Federl (7/23/2009)

---

The case that the rows are inserted in an order that matches a specificed "order by" clause is coincidental and is documented in Books OnLine

When used together with...

Agreed. A function won't do. That said - if you were to replace the word function with "stored procedure", and you probably could do what you're looking at.