Declare @tbTMP Table (chProductNumber VARCHAR(15))
Declare @chProductNumber VARCHAR(15)
Insert @tbTMP
Select 'QCN14AU10'
Union ALL
Select 'QCN14AU11'
Declare CUR CURSOR FOR
Select * From @tbTMP
Open CUR
Fetch Next From CUR
Into @chProductNumber
While @@FETCH_STATUS = 0
Begin
Print 'Product ID: ' + @chProductNumber
Exec spExtendDate @chProductNumber
Fetch Next From CUR
Into @chProductNumber
End
Close CUR
Deallocate CUR