Thank you for the reply...Appreciate your help...Actually I found the solution....What I did was just created two temp tables with different category codes and field values in my stored proc...

Thank you for all help...appreciate it

you can check the attachment..

In this the immediate due should give me the date from dt_pcp_eff and

if schedule_pymnts is empty then no_curr_amt should have dt_pcp_eff date

and other rows from...

by mistake i pasted twice....

Thank you for replying and giving me right direction...I have one more thing...I have a table with a column which includes atleast 2000 rows same as I mentioned one...So how...