Sorry for the lag in response and thanks for the replies and ideas!

I will be playing with this again this week, so I'll post some progress soon 🙂

Thanks

Jamie

The order table is :

CREATE TABLE [dbo].[Order](

[OrderID] [int] IDENTITY(1,1) NOT NULL,

[OrderDate] [datetime] NOT NULL,

[AgentBatchID] [int] NOT NULL,

[FulfillmentCenterBatchID] [int] NULL,

[CustomerName] [nvarchar](50) NULL,

[AddressID] [int] NULL,

[Phone] [nvarchar](50) NULL,

[ProductID] [int] NULL,

[UnitAgentRemit] [money] NULL,

[UnitAgentBonus] [money]...

HI Sean - Thanks for the reply - the two tables are pretty simple:

CREATE TABLE [dbo].[ValidationMessage](

[ValidationMessageID] [bigint] IDENTITY(1,1) NOT NULL,

[ValidationMessageTypeID] [int] NOT NULL,

[Text] [nvarchar](max) NOT NULL,

[ToBeDeleted] [bit] NOT NULL,

CONSTRAINT...