HI Jeff

the field is numeric that contains the date parts - I tried another variation just not getting the required result --

UPDATE GOLD_BROKER_OUTPUT

SET MAT_GWP = (

...

Use below replace GOLD_BROKER_OUTPUT WITH THE TABLE YOU NEED TO DROP IS EXISTS

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GOLD_BROKER_OUTPUT]') AND type in (N'U'))

DROP TABLE [dbo].[GOLD_BROKER_OUTPUT]

Thanks Karl for all your help - you have been a STAR:)

Its just about doing what I want - a little more tweeking and I will have what I want...

HI Karl - apoligies - feel its nearly complete - just my inexperience stepping in !!

The Company numbers are unique as is the agency numbers, they and bus , trad...

HI Karl

The data fields are

Company - int

Agency - nvarchar

bus lines - nvarchar

trad seg - nvarchar

The rows to be created for example,,

company number 5667 has 7 agencies in the...

Thanks Karl -what a quick and very impressive response

The code works great - 99% complete

Apologies as fairly new to SQL - how do I create a new table with the...