abinder (6/19/2008)
You're correct, Matt. I have this aversion to writing dynamic SQL although I have used it in the past. It is awkward at best and I have read many reasons why not to use it (although I feel some of the negatives are overstated). I thought there might be some kind of magic I have overlooked. In retrospect, I will use it since I don't think I have a real alternative.BTW, you have one too many apostrophes around the %39% on each side.
Thanks for your response to this question and also my last posting on Aging Reports.
Alfons
Very likely on the apostrophes - I didn't try to put anything together to validate.
Otherwise - you're welcome! Good to hear that it helped.....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?