create table some_base_table (
    batch_id        int not null primary key clustered,
    batch_name      varchar(250) not null,
    some_parm       int null,
    some_parm2      int null
)
 
insert some_base_table ( batch_id, batch_name, some_parm, some_parm2 )
    values( 1, 'hello fred', 1, 2 )
insert some_base_table ( batch_id, batch_name, some_parm, some_parm2 )