SELECT viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber,
viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty,
viewCoreCheckIn.StagingCurrentQty,
viewCoreCheckIn.PreInventoryQty,
COALESCE (- (viewCoreCheckIn.MinCheckInQty +
viewCoreCheckIn.MinPreInventoryQty +
viewTotalReleasedQtyRemaining.TotalQtyNeeded -
viewCoreCheckIn.StagingCurrentQty
+ viewCoreCheckIn.PreInventoryQty), 0) AS
TotalQtyNeeded,
COALESCE (- (viewCoreCheckIn.MinPreInventoryQty
+ viewTotalReleasedQtyRemaining.TotalQtyNeeded -
viewCoreCheckIn.PreInventoryQty), 0)
AS PreInventoryQtyNeeded
FROM viewCoreCheckIn LEFT OUTER JOIN
viewTotalReleasedQtyRemaining ON
viewCoreCheckIn.TonerTypeKey =
viewTotalReleasedQtyRemaining.TonerTypeKey
WHERE (viewCoreCheckIn.TonerTypeKey = @TonerTypeKey)
If I call the query from code or use preview data on the table
adapter, depending on the @TonerTypeKey the adapter will give me the
following error message
"Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding"
However, if I run the query from Sql Management studio or do Configure
->Query Builder -> Execute Query in the table adapter the query runs
in less than a second.
Any ideas as to what may be going on?
thanks,
Luis