So use C#.

Something like this?

--return the previous record where type is F as well.
SELECT tl1.ID, tl1.[type] as ClientType, tl1.ClientName, tl1.completedOn, tl1.CustName, tl1.CustID, tl1.PreviouslyCompletedID,
prev.id, prev.clienttype, prev.clientname, prev.CompletedOn
FROM #temp_Lookback tl1
CROSS APPLY...

Use LAG() to look at a previous record

Upgrade and use STRING_AGG?

use tempdb;
go

 create table #PartsFeature
 (
 PartId int,
 Featurekey nvarchar(200),
 FeatureValue nvarchar(200),
 );
 go

 insert into #PartsFeature(PartId,Featurekey,FeatureValue)
 values
 (1550,'Botato','Yellow'),
 (1550,'Mango','Red'),
 (1550,'dates','Black'),
 (1600,'Rice','white'),
 (1600,'macrona','Red'),
 (1600,'chicken','Yellow'),
...

• This reply was modified 4 years, 1 months ago by pietlinden.

Calculate week numbers for each sale record, then you can do something like

SELECT WeekNo = t.N, ProductID, ca.Total_Sales, ca.rnk 
FROM Tally t
CROSS APPLY (SELECT TOP 10 ProductID,...

DECLARE @MyDate DATE = '10/9/2021';

SELECT DATEPART(week,@MyDate);

DATEPART(week,[DateColumn]) will return the weeknumber of the year. Just group on that.

Help yourself. Introduce yourself to the help files on SQL Server.

You'd have to use IIF([Date1]>=[Date2],[Date1],[Date2]) Then maybe do an aggregate on that expression.

Isn't the total distance covered the sum of all distances up to this pass? If that's the case, then why not use a windowing function and sum(distance)? and then use...

Maybe Jeffrey was too subtle...

You really need to read this article:

Forum Etiquette: How to post data/code on a forum to get the best help

I'd post my attempt, but I...

• This reply was modified 4 years, 2 months ago by pietlinden.

Depends what the database is doing at the time. Requests get queued until the database can process the request, so sometimes it takes very little time, sometimes it takes more...

There's one big thing you are missing from your question - What are you trying to accomplish?  Changing the EXISTS clause to a join will cause you to have duplicate...

• This reply was modified 4 years, 2 months ago by pietlinden.

You have data. How about posting CREATE TABLE and INSERT scripts so we can see what you're working with? While you're at it, post the expected result... but for the...

Something like this? (I may be oversimplifying something...)

-- exclude when phone # refers to multiple people.

-- exclude when phone # refers to multiple people.
SELECT * FROM CustomerPolicies...

The easiest way is to use a Calendar table and explode the join

-- DROP TABLE #t
CREATE TABLE #t (CustNo int, Net money, StartDt datetime, EndDt datetime)
INSERT INTO...

• This reply was modified 4 years, 2 months ago by pietlinden.

use TOP() or LIMIT and do the delete in batches until @@ROWCOUNT = 0?