Just...

It apparently cannot make the distinction between "temp tables" and "temporary tables".  It's seriously incorrect for what most of us refer to as "temp...

BWAAA-HAAA-HAAA!!! You're on my bucket list, Mr....

Thats because you’ve not met me 😳

Maybe I'm still suffering from insufficient caffeine levels this morning, but I have to admit, David, I'm confused.  Why did you change the row numbers from what the op...

WITH cte AS (
SELECT[Table].*
FROM (VALUES
(1,NULL,'2022-12-01T14:10:37.050',NULL,1),
(1,NUll,'2022-12-02T12:10:31.070','Hold',2),
(1,NULL,'2022-12-06T11:18:52.040','Load',3),
(NULL,10,'2022-12-04T15:14:14.050','Review',1),
(NULL,10,'2022-12-05T09:22:46.150',NULL,2),
(NULL,10,'2022-12-15T10:15:18.520',NULL,3),
(NULL,10,'2022-12-17T09:22:46.150','Buy',4)
) [Table] (CustId,LeadId,[Date],Advice,[Row])
)
SELECT cte.CustId,cte.LeadId,cte.[Date],cte.Advice,cte.[Row],ISNULL(c.Advice,l.Advice) AS [NewAdvice]
FROM cte
OUTER APPLY (
SELECT TOP(1) cte2.Advice
FROM cte cte2
WHERE cte2.CustId=cte.CustId
AND cte2.Advice IS NOT NULL
ORDER BY ABS(DATEDIFF(minute,cte.[Date],cte2.[Date])) ASC
) c
OUTER APPLY...

• This reply was modified 1 year, 3 months ago by  David Burrows.

Use a different Row Delimiter

• This reply was modified 1 year, 3 months ago by  David Burrows.

Same to you, ol' friend.  Glad I got to know you and others from this site.  Missed...

Use delimited split using pipe as delimiter and then use MOD to select 1st and 3rd items

Step 1 would be to query just the view to see if the date range returns anything.  Then add a piece of your query for one of the joins...

Check if tempdb collation is different to your database(s) the last time time I had this problem that was the cause and as already stated you have use COLLATE on...

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.

Or is...

I have seen this where month name is the column heading but the grouping is date or year/month. Matrix column grouping should be month number only and the heading month...

As a hard and fast rule no. But high cpu can sometimes be caused by high io and that can definitely be a symptom of poor queries as Jeff indicated....

I would check for any correlation between excessive IO and high cpu. Insufficient paging file space will cause sql server excessive page swapping and therefore high IO. Second is there...