create table bbc 
(id int,st_date date,end_date date,status_id nvarchar(200))

insert into bbc values (5,'2012-10-08','2012-10-08','Paid')
insert into bbc values (4,'2012-10-06','2012-10-06','Approved: Ready for Pay')
insert into bbc values (3,'2012-10-03','2012-10-03','Submitted')
insert into bbc values (2,'2012-10-01','2012-10-01','Authorizd Required')
insert into bbc values (1,'2012-10-01','2012-10-01','Draft')
insert into bbc values (5,'2012-09-05','2012-09-06','Paid')
insert into bbc values (4,'2012-09-05','2012-09-05','Approved: Ready for Pay')
insert into bbc values (3,'2012-08-30','2012-08-30','Submitted')
insert into bbc values (2,'2012-08-29','2012-08-29','Authorizd Required')
insert into bbc values (1,'2012-08-29','2012-08-29','Draft')

go