DECLARE @Table1 TABLE
    (LinkID INT, Price MONEY, Date DATETIME)

INSERT INTO @Table1
SELECT 1166,1500,'2012-11-15 00:00:00'
UNION ALL SELECT 1166,1300,'2012-10-01 00:00:00'
UNION ALL SELECT 1166,1000,'2012-05-15 00:00:00'
UNION ALL SELECT 2020,2000,'2012-09-09 00:00:00'
UNION ALL SELECT 2020,1750,'2012-07-01 00:00:00'

DECLARE @Table2 TABLE
    (LinkID INT, Price MONEY, CreatedDate DATETIME)

INSERT INTO @Table2
SELECT 1166,NULL,'2012-12-01 00:00:00'
UNION ALL SELECT 1166,NULL,'2012-10-05 00:00:00'
UNION ALL SELECT 1166,NULL,'2012-10-01 00:00:00'
UNION ALL SELECT 1166,0,'2012-08-02 00:00:00'
UNION ALL SELECT 2020,NULL,'2012-10-09 00:00:00'
UNION ALL SELECT 2020,NULL,'2012-07-02 00:00:00'

UPDATE a
SET Price = (
    SELECT TOP 1 Price 
    FROM @Table1 b 
    WHERE a.LinkID = b.LinkID AND Date < CreatedDate
    ORDER BY Date DESC)
FROM @Table2 a

SELECT *
FROM @Table2