Yes, objParam1 & objParam2 have values in the .Parameters.Append lines, however the values have the format dd/mm/yy. The table definition shows DocumentDate as type datetime. I have placed the sp in the code section.
ALTER PROCEDURE dbo.flolivesp_POPOrderChaser
(
@startdate DateTime,
@enddate DateTime
)
AS
(SELECT TOP (100) PERCENT Floyd.dbo.PLSupplierAccount.SupplierAccountNumber AS popoc_SupplierAccountNumber,
Floyd.dbo.PLSupplierAccount.SupplierAccountName AS popoc_SupplierAccountName,
Floyd.dbo.POPOrderReturn.POPOrderReturnID AS popoc_POPOrderReturnID, Floyd.dbo.POPOrderReturn.DocumentNo AS popoc_DocumentNo,
Floyd.dbo.POPOrderReturn.DocumentDate AS popoc_DocumentDate,
Floyd.dbo.POPOrderReturn.RequestedDeliveryDate AS popoc_RequestedDeliveryDate,
Floyd.dbo.PLSupplierLocation.AddressLine1 AS popoc_AddressLine1, Floyd.dbo.PLSupplierLocation.AddressLine2 AS popoc_AddressLine2,
Floyd.dbo.PLSupplierLocation.AddressLine3 AS popoc_AddressLine3, Floyd.dbo.PLSupplierLocation.AddressLine4 AS popoc_AddressLine4,
Floyd.dbo.PLSupplierLocation.PostCode AS popoc_PostCode,
PLSupplierTelephoneVw.plst_SupplierTelehoneNumber AS popoc_SupplierTelephoneNumber,
PLSupplierFaxVw.plst_SupplierFaxNumber AS popoc_SupplierFaxNumber,
Floyd.dbo.PLSupplierAccount.SYSCountryCodeID AS popoc_SYSCountryCodeID, Floyd.dbo.SYSCountryCode.Name AS popoc_CountryName
FROM Floyd.dbo.SYSCountryCode INNER JOIN
Floyd.dbo.PLSupplierAccount INNER JOIN
Floyd.dbo.POPOrderReturn ON Floyd.dbo.PLSupplierAccount.PLSupplierAccountID = Floyd.dbo.POPOrderReturn.SupplierID INNER JOIN
Floyd.dbo.PLSupplierLocation ON Floyd.dbo.PLSupplierAccount.PLSupplierAccountID = Floyd.dbo.PLSupplierLocation.PLSupplierAccountID ON
Floyd.dbo.SYSCountryCode.SYSCountryCodeID = Floyd.dbo.PLSupplierAccount.SYSCountryCodeID LEFT OUTER JOIN
PLSupplierTelephoneVw ON Floyd.dbo.PLSupplierAccount.PLSupplierAccountID = PLSupplierTelephoneVw.plst_PLSupplierAccountID LEFT OUTER JOIN
PLSupplierFaxVw ON Floyd.dbo.PLSupplierAccount.PLSupplierAccountID = PLSupplierFaxVw.plst_PLSupplierAccountID LEFT OUTER JOIN
POPOrderChaserExcludedOrdersVw ON
Floyd.dbo.POPOrderReturn.POPOrderReturnID = POPOrderChaserExcludedOrdersVw.popeo_POPOrderReturnID
WHERE (Floyd.dbo.POPOrderReturn.POPOrderReturnID IS NULL) AND (Floyd.dbo.POPOrderReturn.DocumentTypeID <> 1) AND
(Floyd.dbo.POPOrderReturn.DocumentDate >= @startdate) AND (Floyd.dbo.POPOrderReturn.DocumentDate <= @enddate))
RETURN
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30:





by: LSMConsultingPosted on 2008-12-12 at 10:06:49ID: 23159499
Have you verified that your dblStartDate and dblEndDate are filled before passing them to the parameters?