[RESOLVED] [SQL 2000] Conditional Conditions in SP

[RobDog888]

Hmm, makes sense I think but could I or is it better to use a dynamic To date function?

CREATE PROCEDURE [dbo].[usp_LoansFilter] AS 
	@From datetime = '01-Jan-1800',
	@To datetime = GetDate(),
	@Status nvarchar (15) = Null,
	@Scope nvarchar (15) = Null