Question : I have a query which I was running in Microsoft SQL server and it worked just fine. It […]
Tag: cte
Index on a Computed Column(using udf)
Question : I am trying to create a computed column using a udf. I keep hitting the cannot be persisted […]
How do I return all column values for the recently inserted row/rows?
Question : I have these two tables in a PostgreSQL 12 database: CREATE TABLE public.test ( entity_id uuid PRIMARY KEY […]
Index converted from Seek to Scan in CTE
Question : SQL Server version: Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) – 15.0.4083.2 (X64) Nov 2 2020 18:35:09 Copyright (C) […]
PostgreSQL Recursive Descendant Depth
Question : I need to calculate the depth of a descendant from it’s ancestor. When a record has object_id = […]
Performance: CTE in an “IN”-Operator
Question : I’ve got a query with a CTE (getting all children of a parent) followed by a main statement […]
SQL Conditional Join – remove duplication from Stored Procedure
Question : This stored procedure accepts a search parameter. I want to join on a table valued function if the […]
Oracle database – get two rows (A,B) for every (COD) row
Question : I have a Oracle database and a variable that can have a value for A and a value […]
Update rows based on a recursive CTE query result
Question : This query shows all lines recursively based on a uuid / parentUUID relationship: WITH RECURSIVE files_paths (id, parent) […]
Making a recursive CTE like query, but for many records
Question : I have a table with a hierarchy ( with a recursive parentID column), for one record, I know […]