Amazing thank you very much

Thank you John,

Sample data below.  Many thanks

-- Sample data
IF OBJECT_ID('tempdb..#SampleData') IS NOT NULL DROP TABLE #SampleData
SELECT * INTO #SampleData FROM (VALUES...

Thanks, converted to PDF as requested.  Many thanks

HI Drew, whilst I appreciate what you are saying;  as a newbee to sql all I'm trying to do is find a solution to a problem,  The solution ChrisM gave me to...

Hi Drew,

thanks for coming back to me.  I can't really post expected results as I dont know how to join to [SEQ2].  This is what I am trying to...

Hi Chris, I'm hoping the below will now make a bit more sense. The objective of this is in text at the bottom of the query.  Thanks in Advance

Thanks Chris, I understand how this is confusing for everyone here after re-reading what I have posted. I work on creating better sample data showing exactly what I am trying...

here is the sample data with the error message.  Many thanks

IF OBJECT_ID('tempdb..#SampleData', N'U') IS NOT NULL
  BEGIN
  DROP TABLE #SampleData;
  END;

SELECT...

thanks guys, yes all data is in the same table i'm just trying to get the below from query 1 to show as a new column in query 2 if...

Hi Thom A

So ideally i would like to have another column in Query2 showing the output from Query1 so something like the below as a final query

thank you for this steve, when I run the query it shows the following message

'

(6929585 rows affected)

(1573534 rows affected)

Msg 207, Level 16, State 1,...

sample data coming soon, apologies

Thanks all,  sample data below.  Hoping to achieve -  If the ref is duplicated it only counts it once rather than 3 (as in the example below)

--...

sorry what is meant by DDL and DML?