-- Create output table
	DECLARE @Output TABLE (
		[Id] INT,
		[LocaleCode] VARCHAR(5),
		[Content] NVARCHAR(MAX),	
	)
	
	-- Create language cascade table
	DECLARE @Cascade TABLE (
		Locale varchar(5)
	)
	
	-- Load in language cascade data
	INSERT 
		@Cascade
	EXEC
		GetCultureCascade @Locale
	
	-- Cursor vars
	DECLARE @CurrentLocale NVARCHAR(5)
	DECLARE @MissingTrans INT
	DECLARE @First BIT
	
	DECLARE @Id INT
	DECLARE @LocaleCode VARCHAR(5)
	DECLARE @Content NVARCHAR(MAX)
	
	DECLARE @Count INT
	
	-- Set @First = 1 to force the first cycle
	SET @MissingTrans = 0
	SET @First = 1
		
	-- Cursor time
	DECLARE LocaleCursor CURSOR FOR
	SELECT
		[Locale]
	FROM
		@Cascade
		
	OPEN LocaleCursor
	
	-- Fetch locale into the cursor
	FETCH NEXT FROM LocaleCursor INTO @CurrentLocale
	
	-- While fetching is possible and there are (missing translations or first cycle)
	WHILE @@FETCH_STATUS = 0 AND (@MissingTrans > 0 OR @First = 1)
	BEGIN
		-- Load content
		DECLARE ContentCursor CURSOR FOR
		SELECT
			[R].[Id],
			[RL].[LocaleCode],
			[RL].[Content]
		FROM
			[Resource] AS [R]
		LEFT JOIN
			(
				SELECT
					*
				FROM
					[Localisation]
				LEFT OUTER JOIN
					[Locale]
					ON
						[Locale].[Id] = [Localisation].[LocaleId]
					WHERE
						[Locale].LocaleCode = @Locale
			) AS [RL]
			ON
				[R].[Id] = [RL].[ResourceId]
		
		-- Open content cursor
		OPEN ContentCursor
		
		-- Get first record
		FETCH NEXT FROM ContentCursor INTO @Id, @LocaleCode, @Content 
		
		-- Start looping
		WHILE @@FETCH_STATUS = 0
		BEGIN
			-- First locale cycle, insert them all
			IF(@First = 1)
			BEGIN	
				INSERT INTO @Output 
					([Id], [LocaleCode], [Content])
				VALUES
					(@Id, @LocaleCode, @Content)
			END
			ELSE
			BEGIN
				-- It is, update it if the content is empty
				UPDATE @Output SET [Content] = @Content WHERE [Id] = @Id AND [LocaleCode] IS NULL
			END
			
			-- Continue content loop
			FETCH NEXT FROM ContentCursor INTO @Id, @LocaleCode, @Content 
		END
		
		-- Cleanup
		CLOSE ContentCursor
		DEALLOCATE ContentCursor
			
		-- Check to see if any content is missing. If not then the loop can be broken
		SELECT 
			@MissingTrans = COUNT(*) 
		FROM
			@Output
		WHERE
			[Content] IS NULL
			
		-- No longer the first
		SET @First = 0
		
		-- Next
		FETCH NEXT FROM LocaleCursor INTO @CurrentLocale
	END
	
	-- Tidyup
	CLOSE LocaleCursor
	DEALLOCATE LocaleCursor
	
	-- Output
	SELECT * FROM @OUTPUT