Good to know

Looks like we are thinking in the same line today

I don't think so I believe he didn't payed attention because of the fact that names returned had some sence. Pretty sure he'll be back, just not when

Agree with Remi here. We STILL don't know what was actually needed

I hear you, Lets just hope that the Poster kept reading the thread or he will be in for a BIG surpirse  

As expressed above you need to clarify what are you doing with CODE and DATA samples. It is very difficult to help you  if you don't cooperate

You don't need to do anything very complicated to see that when you write max() of several columns you are going to get the max of each independently of what...

I have to differ here:

I am pretty sure that fahnlon's is wrong ( no offense )

When you perform  those max() are retrieving the...

The name of the Game in this case is USAGE. How is it going to be used?

 There  are many problems associated with data manipulation of text fields the complexity that you...

OR:

select top 10 e.emp_id, e.fname, e.lname , e.job_lvl

from employee e join

 (select job_lvl, min(emp_id) minID

 from employee

 group by job_lvl ) lvls on lvls.minID =  e.emp_id and lvls.job_lvl = e.job_lvl

order by e.job_lvl

???...

Be careful, you may get burn

if that "batch" has GO in it, then GO is a batch separator therefore each create table is one batch  

>> There's no way they can come up with a bug free product. <<

Absolutely correct but there are some bugs bigger than others. With todays XP technologies, regresssion tests environments and all...

If what you mean is that the trigger inserts data in a destination table and that table is replicated then yes it is possible to do that but if what...

Me neither but they are the ones with the big $$$.

With Power comes responsibility