Recursive CTE across 2 tables to find the top of the hierarchy

Create a documents table:

Group by clause SQL Server

I’m trying to extract some data from an SQL database and work with it to get some basic figures for a financial report.

Trying to under how to query using a SQL hierarchy in 2 tables

Create a documents table:

Difficult to solve SQL example [closed]

Closed 1 min ago.

Group by column and merge multiple rows into one row with multiple columns

Please help me this:

Group by column and merge multiple rows into one row with multiple columns

Please help me this:

Query to check status change of an item

I have a table dbo.tblPresentationStatus (SQL script for table at the bottom).

Query to check status change of an item

I have a table dbo.tblPresentationStatus (SQL script for table at the bottom).

Query to check status change of an item

I have a table dbo.tblPresentationStatus (SQL script for table at the bottom).

How to get latest child table id based on condition

I am writing one query to get results based on parent table records and latest child table id based on condition