-- sp_GL_Prop_SecAgent_SettlementDate_EarlierThan_DueDate
declare
	@BookingID varchar(32) = 'AGS00000000000011',
	@Date datetime = '20180215',
	@LastDate datetime = '20180213',
	@Value bit

begin

	declare @CfId int



	declare @settlementDate datetime

	declare @dueDate datetime



	select @Value = case when c.DueDate > c.modSettlementInterestDate then 1 else 0 end

	from Ac_Agent aa

		inner join [Security] s on aa.[Security]=s.id

		inner join Cashflow c on s.Cashflow=c.id

	 where aa.BookingId=@BookingID

		and c.DueDate=@Date



	select @Value=ISNULL(@Value,0)

end
select @Value