I want when GRN_ID is change ,then S_NO must start from 1, then do increment of one on every insertion in database ,until unless GRN_ID is not get change.
it should be auto generated S_NO.
below is data in which i have given two grn_ID ,S_NO is getting change
Create table #tbl_GRN_Detail (GRN_ID int,Item_Code int,Item_Weight int,S_NO int)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (1 ,1,5000,1)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (1 ,2,410,2)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (1 ,7,333,3)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (2 ,11,5001,1)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (2 ,24,411,2)
insert into #tbl_GRN_Detail(GRN_ID ,Item_Code,Item_Weight,S_NO ) values (2 ,74,331,3)
