Dear experts,
I have error when trying to call stroed procedure. The procedure is fairly simple
select distinct a.keyid, a.distrikct, round(a.area_parcel,1) area_parcel, round(a.area_grid,1) area_grid, round(a.actual_felling,1) as felling, round(a.actual_extraction,1) as extraction, a.actual_sap sap,
case
when round(a.area_grid,1) = round(a.actual_extraction,1) and round(a.area_grid,1) = a.actual_sap then '+'
else '-'
end as status,
case
when b.grid_status = '5' then 'complete'
else 'Not Complete'
end as complete
from regional_app.dbo.opsplan_atable a
left join ( select distinct keyid, grid_status from regional_pki.sde.view_POLYHIP where [status] in ('1','2') and grid_status ='5') b
on a.keyid=b.keyid
where a.distrikct = @distrikct
the error is : timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding. It only occurs for a particular @di ...
Go to the complete details ...