CREATE TABLE #tblBatch
       (BatchId  INT   NOT NULL IDENTITY(1,1) PRIMARY KEY,
        Sname VARCHAR(50) NOT NULL,
        BatchNo int,
        BatchSequenceNo int
        )

---Load some sample data
INSERT INTO #tblBatch(Sname)
Select top 2010 'A -SampleText-'+cast(row_number() over(order by t1.number) as varchar) as N
from   master..spt_values t1
       cross join master..spt_values t2