It souldn't make any difference.
>My companytable got over 35 fields (include 4 address field nvarchar(50)X 4, contact person.. etc)
>Now I need to insert to company code and company name into a temp table.
>
>(1) insert into myTemp(...) select .... from companytable
>OR
>(2) I create a view first which only select 10 fields from companytable
>insert into myTemp(....) select .. from myView
>
--sb--