how to use between in sql server 2008 r2

how to use between in sql server 2008 r2

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
       AND  C.COMPANYID=ISNULL(@CompanyID, C.CompanyID)
       AND  SC.EndDate BETWEEN GETDATE() and GETDATE()+ @ExpDays
END 


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^