SELECT

t.tranname,

planname

FROM #temptable t INNER JOIN

(SELECT

tranname,

MIN(priority) as min_priority

FROM #temptable

GROUP BY tranName) t1

ON t.tranName = t1.tranName AND t.priority = t1.min_priority

thank you so much. it worked for me.

Thanks a lot.

OK, I am trying again. I have to put space between chars so that it won't unescape when it was posted.

It gave me

1& l t ;A...

thanks. but it didn't give me what I need.

probably when I copied, it unescaped again.

this was the result I got:

1<A>, <B>, <C>, <D>,

2<E>, <U>, <Z>,

3<G>,...

Yep, agree replication is neat, and set it up is easier than go through people comfort zone.;-)

we are a small shop, and I am the only dba. Management prefers software because in the case I am on vacation, somebody else can handle the sync.

thanks.

did you solve your problem yet? I am having the same issue. My SQLmail had worked for years and it broke a couple of days ago. SQL...

thanks for all your replies, and sorry for my late response, I was away for a few days.

the left join query gave me the exact result that I wanted. ...