![]() Extrect all Credit records in a separate table say crTab for just previously read custId and set vCrFlg=0ĥ. Table and set vDrFlg variable value to 1Ĥ. Start a infinity loop and With in this loopģ. Declare some variabale / flage and set there values to 0Ģ. Invoice Details in a separate Table say drTabĢ. Logic Of Data Transformation : This solution is based on structural programming gimmicksġ. Resident trnTab where trnType='Dr' order by custId,trnDate I will try to suggestion on this from Mr. I could not found other better way may others have.īut I am not satisfied with this salutation because it will reduce the performance due to havey use of if then else block. Solution to your query is based on structural programming approach.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |