I have about 50 sql's and for every sql I have to do some insert and deletes before and after it is done. For example..


insert into tableA ...values(id=1....)
Run the 1st query
insert into tableB ...values(id=1...)


insert into tableA ..values(id=2..)
run the 2nd query
insert into tableB..values(id=2...)


etc

I am thinking of adding each of these to a dataset. Therefore approximately I will have 50 datasets.

Is there any way in SPUFI I could run all the 50 datasets at one time otherwise do you think it is advisable to add all of them to a single dataset.

Thanks