--calendar
declare @tab table (d smalldatetime)
insert into @tab (d) VALUES('20150101')
insert into @tab (d) VALUES('20150102')
insert into @tab (d) VALUES('20150103')
insert into @tab (d) VALUES('20150104')
insert into @tab (d) VALUES('20150105')
insert into @tab (d) VALUES('20150106')
insert into @tab (d) VALUES('20150107')
insert into @tab (d) VALUES('20150108')
insert into @tab (d) VALUES('20150110')
insert into @tab (d) VALUES('20150111')

-- motivacii
declare @m table (d1 smalldatetime, i int, f varchar(10))
insert into @m (d1, i, f) VALUES('20140103', 5, 'ccsr1')
insert into @m (d1, i, f) VALUES('20150105', 10, 'ccsr2')
insert into @m (d1, i, f) VALUES('20150108', 7, 'ccsr3')

select
	tt.*, t2.i, t2.f
from
(
select t1.d, (select max(d1) from @m where d1 <= t1.d) as maxD
from @tab t1
) tt
inner join @m t2 on tt.maxD = t2.d1 

select 5, (select 8) as dd

--на языке 1с
ВЫБРАТЬ 5, (ВЫБРАТЬ 8) КАК dd