JL> hi guys,
JL> I have this stored procedure:
JL> CREATE PROCEDURE newClient
JL> StartDate datetime,
JL> EndDate datetime,
JL> cManager nvarchar(20)
JL> Select 'Total ' as [NEW CLIENT], count (ClientID)
JL> as total FROM [Client Intake]
JL> where Manager=cManager AND Date>=StartDate AND
JL> I want it to return all new client for ALL Manager
JL> if the user doesn't supply cManager.
JL> How can I do this?
set cManager default value to NULL and then