set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO






create PROCEDURE [dbo].[STPList_CheckOutForScadule]
@today char(8)=''
AS
SELECT     CheckOUTTBL.CheckDate
FROM         CheckOUTTBL LEFT OUTER JOIN
                      [VW_LinkTo_Account&Title] ON CheckOUTTBL.FK_DocSysCode = [VW_LinkTo_Account&Title].LinkFrom
WHERE     ([VW_LinkTo_Account&Title].LinkToTitle IS NULL) AND (CheckOUTTBL.CheckDate <= @Today)