Yes there is no way a dummy entry in to the table.@

Here is the View Sscript

create view MyView with schemabinding

AS SELECT

 ds.s_id  ,

 ds.e_id  ,

 ds.s_name  ,

 ds.e_name,

 RTRIM(ds.ds_m)  ,

 ds.mat_nm  ,

 CONVERT(datetime,ds.adate,112) adate ,

 ds.cid  ,

 ds.scode  ,

 ds.tcode ,

 ds.mstamp ,

 ds.ncount,

 ds.ll,

 bi.itypeid

FROM dbo.ds

 LEFT OUTER JOIN dbo.bi ON ds.series_id = bi.series_id

WHERE...