How to weekly generate dynamic ID

Assuming you want a (MS) SQL solution

declare @lastweek int
declare @currweek int
declare @lastid int
declare @newid varchar(50)

-- get weeknumber of last insert
set @lastweek = (select DATEPART (wk, (select top(1) BatchDate from tblBatch order by BatchDate desc)))
-- get current week number
set @currweek = (select DATEPART (wk, CURRENT_TIMESTAMP))

if @currweek > @lastweek
begin
-- get the last inserted id
    set @lastid = (select top (1) SUBSTRING(BatchID, LEN(BatchName)+1, LEN(BatchID) -3) from tblBatch order by BatchDate desc)
-- create new id
    set @newid = (select top(1) BatchName from tblBatch order by BatchDate desc) + CAST(@lastid + 1 as varchar(50))
end

select @lastweek, @currweek, @lastid, @newid

You can put it in a stored procedure and let it return newid.

Note that you need to add a check for the end of the year where last week (52/53) will be larger than currweek. Also note that newID will be null if the current week is less than or equal to lastweek.

I hope this is more or less what you need and get you on the way.