Hi,

I get the same result without using DISTINCT. Each employees salary differs, therefore for each GROUP BY category the MIN, AVG, MAX should vary.

Here's a snippet of the result...

Simple, yet effective 😉 Thank you GM... You're a star!

Later...

S

Thank you GM... I'll give it a shot and let you know...

Later...

S

Hey GM,

Thanks for the advise. With reference to EXEC sp_trace_setfilter @TraceID, NULL...

It is a habit. I always initialize. You're not going to believe this. The trace was tested on...

Thank you GilaMonster,

A piece of valuable info. Unfortunately the fact that the filter is not applied is getting to me. The result set in Profiler with a duration filter of...

Thank You Grant,

Very insightfull...

Regards,

S

Appreciate the feedback guys! I do agree with both point of views. Thing is there is always a specific set of actions to be taken. I started this thread to...