• there you go Jeff; Call Microsoft and tell them that the premiere RE-BAR avoidance specialist is offering to rewrite any of their 194 stored procs at the everyday low price of $1,000 each...or a 50% discount to re-write all of them as a group; a few weeks work for you and you can treat yourself to some new toys.

    they may not like your code, what with all your code being heavily commented, explained and readable...not really up to typical MS standards..but what the hey.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!