> >declare @temp table (Zip varchar(5), xYear varchar(4), xQuarter varchar(1)); > >insert into @temp (zip,xyear,xquarter) values Select substring(PropertyZip,1,5), SUBSTRING(xYear,1,4), SUBSTRING(xQuarter,1,1) > from [Foreclosure Notices]; >>
insert into @temp (zip,xyear,xquarter) Select substring(PropertyZip,1,5), SUBSTRING(xYear,1,4), SUBSTRING(xQuarter,1,1) from [Foreclosure Notices];