January 26, 2011 at 4:03 pm
Hi all,
I have one result field and one target field and 6 more comparison fields in my temp table and throw them into different categories. for instance
A_low 0.00
B_low 1.00
c_low 2.00
target 2.5
c_up 3.00
B_up 4.00
A_up 5.00
How can I write cursor for comparison of (result n target) . esp when Some of the lowers/uppers are null. Sometimes only B_up is there and only A_low is there and no target. how do I take care of such things. Rightnow I am using huge case statements and I am afraid I may miss out some criteria.
Do you think use of cursor is justified here or case statements are fine?
Thanks everyone for reading.
January 26, 2011 at 8:49 pm
First, you probably don't need a cursor. Second, can't really help you with the info you have provided. Sorry, we can't see from here what you see from there. Please read the first article I reference below in my signature block regarding asking for help. Follow those instructions on what and how you need to post stuff to get the best possible help. Also, don't forget to provide the expected results based on the sample data you will be posting.
The more you do up front, the better we can help, and you will get tested code in return.
Third thing, curious why you think you need a cursor.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply