The page that you linked to contains three separate approaches to a very similar problem.  If you are having problems with one or more of those approaches, show us what...

There are basically two approaches that you can use ROW_NUMBER() and GROUP BY.

• In the ROW_NUMBER() method, you would create a row number with a partition on your columns (Col1,...

The TYPE directive just says to return the results as XML rather than a string. TYPE Directive in FOR XML Queries

Drew

A newbie replied to a decade old post.  I'm not sure you're going to get much info from the original poster.

Drew

EVERY SINGLE TIME you post data you have to be reminded of the best way to post data.  I've come to the conclusion that you don't want to learn, you...

related_resources is an array of JSON and you haven't supplied the index for the array.  The array is zero-based.  See the example below.

Declare @JSON Nvarchar(max) = N'{"notes"...

Maybe STUFF() would work better if this text is always at the beginning.

SELECT STUFF([error], 1, CHARINDEX('Quote', [error])-1, '')

Drew

This produces the exact same results as your working query, but I think that the logic is simpler to follow.

WITH TierChanges AS
(
    SELECT ui.UserID
...

Given the column naming convention, I think there might be a simpler solution than using an EAV.  This assumes that there are three sets of weights: PWT, PNT, and PTT...

I believe that the following solution will perform better.

WITH last_visits AS
(
    SELECT t.primarydoc
 , t.client_id
 , t.visitdoc
 , t.doc_id
 , t.visit_id
 , t.visit_date
 ...

Create some test data:

DROP TABLE IF EXISTS TestTable
GO
CREATE TABLE TestTable
(
    NoSeqTrt INT,
    NoSeqIti INT,
    idPointsrv INT
)
;
GO
-- Populate...

A CTE is part of data manipulation language (DML), specifically an INSERT, UPDATE, SELECT, or DELETE statement.  An IF...THEN...ELSE is a workflow statement.  You CANNOT have a workflow statement in...

So where do these linked integers come from? Why, for example, is 1 linked to 1, 2, and 3, but the numbers 8 to 14 only linked...

Hi Jeff,

Thanks for the response. The Window functions cannot be used in update statements directly, so I used a different technique, whereby I had partitioned the data of unique...