Book and Serial No implement in store pro

Example - Book and Serial No Like (1/001)  

---------------------------------------------------------------------vol sr

declare @VOL_New AS INT, @SrNo as int

 SELECT @VOL_New= ISNULL(MAX(VOL),0) FROM WAQF_RECEIPT_VOL_SR

 

 If @VOL_New=0

BEGIN

insert into WAQF_RECEIPT_VOL_SR values (1,1)

END

else if @VOL_New>0

 begin

  SELECT @SrNo= MAX(SrNo) FROM WAQF_RECEIPT_VOL_SR where Vol=@VOL_New

  if @SrNo=100

  begin

insert into WAQF_RECEIPT_VOL_SR values (@VOL_New +1, 1) 

  end

  else 

    begin

insert into WAQF_RECEIPT_VOL_SR values (@VOL_New ,@SrNo+1) 

    end  

 end

 declare @maxvol as int,@maxsrno as int

 select @maxvol= max(vol) FROM WAQF_RECEIPT_VOL_SR 

 select  @maxsrno=max(SrNo) FROM WAQF_RECEIPT_VOL_SR where Vol=@maxvol

 select @maxvol,@maxsrno