SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SearchVendor_Fees]
@Start_Date DATETIME = NULL,
@End_Date DATETIME = NULL,
@Enter_VendorName NVARCHAR(255)
AS
SELECT     VendorLicense.VendorName, VendorLicense.VendorLicNumber, VendorFees.DebitAmount, 
                      VendorFees.CreditAmount, VendorFees.Date, VendorFees.CheckNumber, VendorFees.Subtotal
FROM         VendorFees INNER JOIN
                      VendorLicense ON VendorFees.VendorLicNumber = VendorLicense.VendorLicNumber
WHERE (@Start_Date is null or VendorFees.[Date] <= @Start_Date)
AND(@End_Date is null or VendorFees.[Date] >= @End_Date)
AND (VendorLicense.VendorName LIKE @Enter_VendorName + '%')

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[VendorFee_Totals]
@Start_Date DATETIME = NULL,
@End_Date DATETIME = NULL
AS

SELECT     VendorLicense.VendorName, VendorLicense.LicenseIssueDate, VendorLicense.VendorLicNumber, VendorFees.DebitAmount, 
                      VendorFees.CreditAmount, VendorFees.Date, VendorFees.Code, VendorFees.CheckNumber, VendorFees.Subtotal
FROM         VendorFees INNER JOIN
                      VendorLicense ON VendorFees.VendorLicNumber = VendorLicense.VendorLicNumber
WHERE (@Start_Date is null or VendorFees.[Date] >= @Start_Date)
	or(@End_Date is null or VendorFees.[Date] <= @End_Date)


ORDER BY VendorLicense.VendorName

WHERE (@Start_Date is null or DATEADD(DAY, DATEDIFF(DAY, 0, VendorFees.[Date]), 0) >= @Start_Date)
	or(@End_Date is null or DATEADD(DAY, DATEDIFF(DAY, 0, VendorFees.[Date]), 0) <= @End_Date)

"There is only one difference between a dream and an aim. A dream requires soundless sleep to see, whereas an aim requires sleepless efforts to achieve..!!"

quote:

---

Originally posted by muzzettemm

Thank you PeterNeo that did the trick

---