Thank, thats exactly what I want 🙂

Asta

Hi thank you for your reply, I dont think just using TOP 15 will work as the list of values will always be different hence I need a way to...

yes the 6th query is the final result set. but I have it working now using temp tables which I drop at the end of the sp. It...

thank, thats sound like it would work, I'll give it a try.

Asta

Thank you very much, I shall keep that in mind.

Asta:-)

thank you for this ver helpful and informative answer. Lots of stuff there that I didn't not know but need to know.

Thanks

Asta

Thanks, glad I asked, saves me looking for something that does not exist.

Asta 🙂

Thank you very much, so are you saying that I need to call this trigger while updating the tblJobsBR and tblJobs, not quite sure how to do that. Just...

hmmm your making me rethink why I want to include certain columns at all when only showing first of looses the relavance of the data. Maybe I dont need...

sorry pressed send by mistake before completing. If I did not First Clause in the Category field my result would be different as you can see. Does anyone know...

Thank you :-). I'd be lost without places like this and it does make me wonder how did people manage with tech problems before we had the internet.

Well it a big company over 300 people so I imaging it must be OK. I guess I should just develop my project on my own PC and not...

work like a dream, thank you very much!

asta 🙂

Barry Tank you so much your a star, will try it out this evening when I get home 🙂 Asta

Barry, Thank you very very much for the code, as soon as I get home I will try it.

Your a star.

Asta 🙂