• Sean Lange (9/4/2012)


    Tava (9/3/2012)


    excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no way i would have solved it.

    But do you UNDERSTAND it? It is great that you have it working but unless you understand it you are only half way done. You are the person getting the phone call at 3am when your production system is down. If you don't understand it then you need to go back and read that article over and over until you do.

    I know, I didn't quiet understand it all and that's just because I'm new to all this, what I did instead was (might not be the best method) took it out of the function and placed it into the Stored Proc instead.

    We had the stored proc calling this function. So that was removed and code was modified.