get the expire date

declare @DesiredDateAtMidnight datetime = '20010709'declare @NextDateAtMidnight datetime = dateadd(day,1,@DesiredDateAtMidnight)select OrderID=h.SalesOrderID
      ,h.OrderDate
      ,h.TerritoryID
      ,TerritoryName=t.Name
      ,c.CardType 
      ,c.CardNumber
      ,CardExpire=right(str(100+ExpMonth),2)+'/'+str(ExpYear,4)      ,h.TotalDuefrom Sales.SalesOrderHeader hleft join Sales.SalesTerritory t on h.TerritoryID=t.TerritoryID left join Sales.CreditCard c on h.CreditCardID=c.CreditCardID where OrderDate>=@DesiredDateAtMidnight 
  and OrderDate<@NextDateAtMidnight order by h.SalesOrderID