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)