Many thanks, exactly what I needed 🙂

OK, here is some example data and schema:

/****** Object: Table [dbo].[LANGUAGES] Script Date: 20/10/2015 14:47:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[LANGUAGES](

[LANG_ID] [nvarchar](10) NOT NULL,

[LANG_NAME] [nvarchar](50)...

Hi, no I'm afraid not. The combination of res_id and res_lang would be though.... but of course, some are missing and these I'm trying to identify.