Counter For Website Procdure----------------------------
CREATE proc sp_select     
as     
Declare @counter bigint   
set @counter=(select top(1) CounterNumber from counter order by updatedon desc)   
set @counter=@counter+1   
insert Counter (counternumber) values (@counter)   
SELECT RIGHT(replicate('0',7)+convert(varchar,@counter),8)  as counter 



OR

CREATE proc sp_select     
as     
Declare @counter bigint   
set @counter=(select top(1) CounterNumber from counter order by updatedon desc)   
set @counter=@counter+1   
UPDATE Counter (counternumber) values (@counter)   
SELECT RIGHT(replicate('0',7)+convert(varchar,@counter),8)  as counter