I am not sure that I understand why you would want to control the order of insert. If there were a column in table 1 that you wanted to...

I have not worked with grades but have a fairly large amount of expierence with applications that need to calculate some type of total from detail records. My recomendation would...

When you call the query you need to set the parameters. It should look someting like this.

declare @dateparm datetime

declare @otherparm char(1)

select @datepart = {?DATE}, @otherparm = {?AorB}

exec your_stored_procedure  @dateparm, @other