Like this:

Select * from dim_concept Where failed = 'N'

UNION ALL

Select * from vw_dim_concept Where Not (failed = 'N')

And why, pray tell, is UNION not an option?

Please do not cross-post.

Note that you can only get this to work with a View (or a table-valued function) if table A and table B have the same number of columns and the...

That error only ever happens on SQL 2000 server (and lower), So I would have to say that the query must actually be going to (or through) a SQL 2000...

OK, thanks.

neneco56: I do not know why this is not working for you, you should only get that error on SQL 2000 systems. Even SQL 2005 databases in compatibility mode...

Glad we could help.

Just out of intrest: what use would you have for being able to set the order of 4 or more triggers?

Hmm, well that is not happening to me. Is it possible that you have set the "persisted" option on the computed column and you are picking up the previous...

Yes, this is a SQL Server 2005/2008 script, because as you will notice at the top of the page, this is a SQL Server 2005 forum and this is the...

Ah, and what version of SQL server are we running on?

Heh, tell me about it. There really is no upside to getting older. 🙂

Yes, my script does work. It is exactly what you are describing, it is "just a simple script", in fact it is a single Select statement. So, you...

You can define the First trigger and the Last trigger, everything else is just in-between them, as per bitbucket's links.

You would need to show us the expression that you are currently using and the datatypes of the columns involved.