store procedur in Sql Server

Question

I have Table Format And record 

TCNo	SR	OANO	OAID	HeatNo
200/16	1	10982	2	PP012
200/16	2	10982	2	PP011
200/16	3	10982	2	PP010
200/16	4	10982	2	PP009
200/16	5	10982	2	PP013
200/16	6	10982	2	PP008
200/16	7	10982	2	PP007

  OutPut Table Like

TCNO	SRNO	OANO	OAID	HeatNo	Pgno
200/16	1	10982	2	PP012	1
200/16	2	10982	2	PP011	1
200/16	3	10982	2	PP010	1
200/16	4	10982	2	PP009	1
200/16	5	10982	2	PP013	1
200/16	6	10982	2	PP008	2
200/16	7	10982	2	PP007	2

 

store procedure parameter pass TCNo And Record per page Integer value Like 5

How it possibe through store procedure