Lab Sql

Running SQL 2005 X64. First, create the following stored proc on a database: CREATE PROCEDURE dbo.… Read more What Leads To This Strange Sql Behavior?

I'm trying to do something usually simple with SQL (with foreign key in the same table for exam… Read more How To Build A Recursive Structure With Mongodb

This code involves a recursive Stored Procedure call and a 'not so great' method of avoidin… Read more T-sql Puzzler - Crawling Object Dependencies

I'll try and explain how the table is laid out so that what I need might be a bit more clear. #… Read more Oracle Sql Recursion To Find First Instance Of Non-null Column Value

I'm having a problem with this exercise: Table Friend: Friend1 Friend2 Table Relationship… Read more Computing Minimum Path Lengths In An Sql Table

I have linked together groups of records which are related via a shared parent. Unfortunately ther… Read more Oracle Sq Identify Siblings Via Siblings

Using MySQL, I want to return a list of parents, from a table that has a field structure like this.… Read more Get A Recursive Parent List

I have a problem that it's very easy to be solved in C# code for example, but I have no idea ho… Read more Sql Implementation With Sliding-window Functions Or Recursive Ctes

I have written a program to generate all possible combinations of strings of length two. The progra… Read more Generate All Possible Combinations Of Strings Of Certain Length In Oracle

We have a table where rows recursively link to another row. I want to pull data associated with a g… Read more Recursively Grab All Data Based On A Parent Id

I've got a 'Task' table with the following columns (the TaskOrder is for ordering the c… Read more Ordering Hierarchy From Recursive Query Results In Sql 2005

I am trying to create a trigger which will update the grades of all the friends of a student whose … Read more How Do I Prevent Trigger Recursion In Sqlite?

I'm not a expert on SQL and I'm working on a huge SQL code and unfortunately it has a CURSO… Read more How To Convert Cursor Based Query In To Set Based

I'm trying to make a function that recursively builds a path for a specific category CREATE FUN… Read more Recursive Stored Functions In Mysql

I currently have 100k+ records in my mysql database that define a person. A person has an ID, a fat… Read more Idea To Approach Sql Family Tree (mysql)

I have a table upload_temp as it follows: CREATE TABLE upload_temp ( codigo serial PRIMARY KEY … Read more Delete Recursive Postgresql

The below table contains details of members and their policies. We need to form a group of 2 or mor… Read more Creating Group For Multiple Columns With Multiple Duplicates

I am working on recursive query which take table with parent-child relation ID | ParentID | descrip… Read more How To Display Parent Id For Itself And Children With T-sql Recursive Query

I want to create hierarchical report in SSRS using this simple table? Could you please help me? I f… Read more Ssrs: Recursive Parent Child