Error in view updatable
The view(SIC7331) definition is as follows
SELECT TOP 100 PERCENT *
FROM dbo.BEA6_USA
WHERE (siccode LIKE '%7331%') OR
(siccode LIKE '%7311%') OR
(siccode LIKE '%7319%')
ORDER BY Companyname,sl_no
when I try to upadate it is giving the error
The view or function is not updatable because the definition contains the TOP clause.
please help me in solving the problem.
|