Thanks Steve Collins--I missed the "The larger query I have has many fields with converts etc. so I am trying not to add the CustomerId to the nested query to...

I threw some data into temporary tables and came up with this:

SELECT customerID, SUM(TargetQty) , SUM(TargetQty) - (SELECT sum(targetqty) from #customerTotals t WHERE t.customerID <> c.customerID) TargetQtySubtractOthers, groupID, acctcD

FROM #customer...

Please appreciate we are all volunteers here with our own jobs, hobbies, families, etc. This is a relatively complicated concept for someone new to sql. You may need to put...

Ok, makes sense. I think you need to partition by employee_id:

drop table if exists #t 
select 1 as payroll_detail_id, 1 as payroll_id, 1 as employee_id, 2 as...

So for payroll id of 3 (employeeID 1 ) you want to get data from  the record payroll_detail_id 1 ? Do you want to get all records for that employee...

Will the lag window function help?

https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

Hi, We figured out how we are going to handle this-- keep the StartDate / EndDate as a datetime and change the values to the beginning of the day meaning...

Thanks for the response Steve Collins.

I wasn't clear in my question. We write the start date of the customer dimension record as a date time,  in the example the StartDate...

Thanks for the response Michael. There are many more attributes in our customer table than just sales rep id. The customer surrogate key s/b the only key in the fact...

declare @text varchar(100) = 'Southeri,Brettuen'

select @text, Replace(@text, ',' ,', ')

You are welcome. I learned something, too,  from Mark C’s solution

Here is what I would do. There may be a different way--without having to "hardcode" every path--but I don't know of one.

DECLARE @doc XML
SET @doc =' ...

I'm not sure how much control you have over the xml, I reformatted it a bit and here is how I would do it:

declare @x xml =...

Cool, glad I could help. I’ve certainly received quite a bit of help from this forum.

🤙🏼

perhaps this will help...

DROP TABLE if exists #batch 
create table #batch (batchID int IDENTITY(1,1), 
            ...