create procedure dbo.searchComplaintdetails
(
	@FirstName nvarchar(50),
	@DueDate DateTime
)
as
select 	Customers.CustomerFirstName as Name,
	ComplaintLog.LogDate,
	ComplaintLog.LogID,
	ComplaintLog.ComplaintStatus,
	ComplaintLog.DueDate,
	ComplaintCategories.CategoryName
from	dbo.ComplaintLog
	Join dbo.ComplaintCategories 
		on ComplaintLog.CategoryID=ComplaintCategories.CategoryID
	join dbo.Customers 
		on ComplaintLog.CustomerID=Customers.CustomerID 
where	    ComplaintLog.IsActive=1
	AND (
		NullIf(@FirstName, '') IS NULL 
		OR Customers.CustomerFirstName LIKE @FirstName + '%'
	)
	AND (
		@DueDate IS NULL 
		OR (
			    @DueDate < ComplaintLog.DueDate
			AND ComplaintLog.DueDate < DATEADD(Day, 1, @DueDate)
		)
	)

quote:

---

Originally posted by Kristen

"why you are converting?"

I presumed because ComplaintLog.DueDate holds time, as well as date.

Kristen

---