You can open a cursor with dynamic SQL. Please refer the following code for it:

[It is a lengthy code, please refer to the section of th cursor]

CREATE PROCEDURE sptdsgen(@tdstype varchar(1),

@fin_year...