Thank you John will look into it.

For the above code i would like to add a small insert code for the generated serial numbers. Suppose for a medicine Batchno Qty...

Can you pls explain the below code

WITH N4 AS (
SELECT n FROM (VALUES (1),(2),(3),(4))v(n)
) 
, N16 AS (
SELECT ROW_NUMBER() OVER (ORDER BY n1.n) AS n
FROM N4 n1
CROSS...

Sure thank you. So far i have not been informed regarding any validations or the batch number Rule configuration . But yes we need to have particular rules to generate...

Haven't created any schema yet...thinking about the logic part before moving into table and schema part

Letter and number combination is saved in a different table (its like a template setting and saved like examples 1. 'ABC12'

2. 'ABCDEFGHIJKL2568',  3.'abcdefghijklmnop589'   4.'14589'  5. ' abcfghyu') . So from...