Your rCTE should start with the original stakeholders, instead of starting with the stakeholder that you are interested in, because you only need to traverse the tree in one direction...

Look up ROW_NUMBER, specifically Example B: Returning a subset of rows. You want to return the subset where the ROW_NUMBER equals 1. You just have to define the...

Boris Pazin (8/4/2016)

---

drew.allen (8/4/2016)

---

There is another approach, but it's a lot more complicated and I would need the information that the others have requested to make a reasonable attempt at...

Have you considered using SEQUENCE instead of an IDENTITY? Sequences are similar to identities, but they're not tied to a specific table.

There is another approach, but it's a lot...

Luis Cazares (8/3/2016)

---

drew.allen (8/3/2016)

---

Luis Cazares (8/3/2016)

---

pnr8uk (8/3/2016)

---

What does the u in this line mean?

...

Luis Cazares (8/3/2016)

---

pnr8uk (8/3/2016)

---

What does the u in this line mean?

(...

You have a main query and three subqueries. The subqueries can only access fields within their scope and the parent's scope. They cannot access fields/tables from the other...

And here is an option changing the last part to a NOT EXISTS. This also assumes that PolicyInsuredLocGK cannot be NULL.

AND NOT EXISTS (

SELECT 1

FROM AIRGBS.vLCExtract AS lc2

WHERE lc.AccountNum...

You can still use windowed functions, but it's a bit more complicated. I would start with something...

You haven't supplied the expected output, but I suspect you are trying to transpose the data rather than pivot the data. You would need to unpivot followed by a...

regan.wick (8/2/2016)

---

Thx David

I read the post you cited. This is the key line from it.

"3.Use inline TVF when possible: In the demo, it’s unnecessary to use a multi-statement TVF....

Part of the problem that you are having is that the IN clause of a PIVOT requires a set of quoted identifiers, but you are supplying expressions. When determining...

Are you sure you don't want your output to look more like this (that is...

Since you are on SQL 2012, have you considered using LEAD/LAG instead of doing a self-join?

Drew

CREATE SYNONYM (Transact-SQL)

---

Synonyms can be created for the following types of objects:

Assembly (CLR) Stored Procedure

Assembly (CLR) Table-valued Function

Assembly (CLR) Scalar Function

Assembly Aggregate (CLR) Aggregate Functions

Replication-filter-procedure

Extended Stored Procedure

SQL Scalar Function

SQL Table-valued...