sudhirnune (4/9/2013)
Chris. I agree with your Query. My problem is that i need to make it Dynamic.I can not use the Static way of implimenting this.
Can you please help me with the Stored proc which can update the data in the Cursor baed on my Formula.
I am looking forward for options to update my Procedure whcih i pasted in one of the posts.
That's straightforward enough. But first, can you explain a little why the query must be dynamic?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden