Anil Singh | Code-sample.com

The given below code-sample might help you to using  BETWEEN  keyword in SQL Server. ALTER PROCEDURE [dbo] . [getContractExpiration] (   @TenantID INT   , @CompanyID INT   = null   , @ExpDays INT ) AS BEGIN SELECT  COM . Name as CompanyName ,             C . NAME ,             SC . ContractID ,             SC . INSTALLATIONDATE ,             SC . STARTDATE ,             SC . ENDDATE             FROM CONTRACT   C         INNER JOIN SERVICECONTRACT SC ON SC . CONTRACTID = C . ID         INNER JOIN COMPANY COM ON COM . ID = C . CompanyID                 WHERE C . TENANTID = @TenantID ...