>Create Procedure SPROC1 > >@PrimeMasterFLID int > >as > > >INSERT INTO MasterOptionFL (MasterFLID) VALUES(@PrimeMasterFLID) > > >EXEC SPROC2 @PrimeMasterFLID > >go >>
>Create Procedure SPROC2 > >@PrimeMasterFLID int > >as > >declare TempAlternates cursor >for > Select * > From MasterOptionFL with (nolock) > Where MasterOptionFL.MasterFLID = @PrimeMasterFLID > >open TempAlternates > >FETCH NEXT FROM TempAlternates INTO @Field1,@Field2,@Field3 >WHILE (@@FETCH_STATUS <> -1) >BEGIN > IF (@@FETCH_STATUS <> -2) > BEGIN > &&MISCELLANEOUS CODE > END > FETCH NEXT FROM TempAlternates INTO @Field1,@Field2,@Field3 >END > >CLOSE TempAlternates >DEALLOCATE TempAlternates > >go >