RAISERROR ( { msg_id | msg_str } { , severity , state }

Exactly why I used big red fonts on "THE ONLY WAY" .

Yup... got bit by that one a few times before I realized how the optimizer works...

Simple one :

Declare @Rank as int

set @Rank = 81

Select O1.Name, count(*) as Rank from dbo.SysObjects O1 inner join dbo.SysObjects O2 ON O1.Name > O2.Name group by O1.Name having count(*)...

Give it a few months... got 2 weeks holidays coming soon (next month). Don't expect to see much of me here while I'm out

1 - I'm online 24/7 as I'm on broadband, and so are you as far as I can tell

2 - Ya maybe

3...

The short version is : the only way to garantee an order in a select is to use the order by clause, otherwise the data will be sent...

Or do you mean that you want different columns showed for different costumers, for the same select?

Did you run that as tsql??

Doesn't mean it's the right thing to do... What if the trigger fails and needs to rollback everything (by design or by big problem). Just for the sake of...

Now that would be a first... a non technical superior guy that thinks he knows how things should work. Never seen that happen before

Thanx .

Don't forget to post the final script with test cases.

Looks like none of us could have done this in a year (except Noeld maybe).

I still can't make this thing work.. what's wrong with it?

if object_id ('FUNCTION_NAME') > 0

drop function FUNCTION_NAME

go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') =...

HTH.