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