>SELECT ManifestHdr.dManifest, ManifestHdr.lOpen, ManifestHdr.iQty,;
> COUNT(ManifestDtl.iPk) AS nScanned, ManifestHdr.iPk,
> Manifesthdr.iFkSystems;
> FROM SN!ManifestHdr;
> LEFT OUTER JOIN SN!ManifestGrp;
> ON ManifestGrp.iFkManHdr = ManifestHdr.iPk;
> LEFT OUTER JOIN SN!ManifestDtl;
> ON ManifestDtl.iFkManGrp = ManifestGrp.iPk;
> WHERE ManifestHdr.iFkSystems = ?vp_ManifestHdr_iFkSystems;
> GROUP BY ManifestHdr.iPk;
> ORDER BY ManifestHdr.dManifest
>
>Any ideas why this is?
>When you put your view in the local DBC, did you get the same network >traffic?
I don't understand what you mean. The DBC is on the server and hence the VIEW, being in the DBC, is on the server . If the DBC were on the local machine network traffic would not be involved.
-Malcolm Donald
Accelerant, Inc.