I am sort of famous for being the "standards Uber Alles" guy in the SQL community. I'm very proud of it and it served me very well. I've written 10...

>> I have a Budget Table in the following format <<

This is very nice of you. Unfortunately, we have to use SQL, so we need DDL instead of a narrative...

There are proprietary temporal functions for formatting dates and working with them. Your code will never port to another SQL product. For example, the ANSI/ISO standard SQL uses the cast...

This puzzle was solved many years ago by Richard Romley. He was an SQL programmer at a Wall Street brokerage firm who likes to write solutions to SQL puzzles. Back...

>> Below is the CREATE TABLE script [sic: statement] NSERT INTO drops my leading zeros. These are important because I have a query that I want to test out that...

The median is actually trickier than you might think. The first question to ask is whether or not the value returned as the median has to exist in the data....

You never read the part of the start of every SQL forum is posted for the last 30 years about providing DDL when you post, did you? You also believe...

Several decades ago I put in a document database (text base) for Southern California Edison. The project was to build a document base for the legal department that handles their...

>> I have never heard of a "tibble", so I googled it. Nothing. Not sure how widespread that term is. <<

The term was coined by Phil Factor and it even...

I think your approach is wrong. A name and a description are two distinctly different kinds of attributes; which one are you using in regard to products? Using a CTE...

To add to what Grant said, you might also want to look out for constraints, triggers, and references on those empty columns..

Jeff Moden wrote:

>> Since I DID provide the DML and a substantial amount of data for anyone (including you) to test with, you...

>> I need help writing a query. I have 2 table with below structure <<

Why did you fail to post DDL?? What you did post has huge problems. Columns are...

To add to what Jeff said, it's really not that hard to write a bunch of stored procedures for the nested set model. I published a few of these in...

You might want to look at the book "The Stable Marriage Problem." By Dan Gisfield and Robert W. Irving. (ISBN-10 02620171185) MIT press. I also posted a solution to this...