Hello

You are likely to get a much faster response if you provide DDL for your sample data. Here's your 'master' table, can you do the same with the 'slave' table? Make sure it runs without errors and that the data is correct before you post it. Thanks.

CREATE TABLE #Master ([No] INT, [Type] VARCHAR(20), [Version] VARCHAR(10), [Date] DATE)

SET DATEFORMAT DMY

INSERT INTO #Master ([No], [Type], [Version], [Date])

SELECT 1, 'Sales', 'V1.0', '01/10/2012' UNION ALL

SELECT 2, 'Consumption', 'V1.10', '29/10/2012' UNION ALL

SELECT 3, 'Daily Needs', 'V1.01', '13/08/2011' UNION ALL

SELECT 4, 'Overall', 'V2.01', '01/09/2012'

SELECT * FROM #Master