This is a direct cut and paste from "SQL for Smarties", you will have to figure out where the data in the tables and stuff should go. But it looks...

>> I have a table of calendar dates with a Y/N flag to denote whether or not the date is a working day. <<

We do not like to write with...

CREATE TABLE Buckets

(bucket_nbr INTEGER NOT NULL PRIMARY KEY,

bucket_size INTEGER NOT NULL

CHECK (bucket_size > 0,

bucket_contentINTEGER NOT NULL

CHECK (bucket_content BETWEEN 0 AND bucket_size)

);

INSERT INTO Buckets (bucket_size, bucket_content,...

If you think SQL's nulls are bad, then look at the IEEE floating-point standards which have NaN (not a number) configurations. The list includes +INF and -INF for positive and...

I would conclude that division by zero is in fact the VERY definition of NULL, and such should resolve to that returned value. I most DEFINITELY would not suspect that...

A declarative language needs orthogonality. Unless something changed in 2016, you cannot pass functions as parameters to other functions in UDFs. In T-SQL dialect, we basically have a copy of...

Disclaimer - Patience please - this is my first go at DB development.

I have to identify records [sic] in a table that has multiple rows, and from the multiple...

It might be true that a CLR, like a cursor could be the best solution for some particular problem. But I have to go along with Jeff; I found that...

I did not call anybody a Luddite; I simply...

And you CELKO

You have devoted a lot of time to review our design and mention my mistakes.

You are great. I was frustrated when I saw loads of faults...

This is not how we intended SQL to be used....

>> We have 4 Tables :

1- Order (Head of orders)

2- OrderItems (Details Of orders)

3- ReturnORD (head of some Orders which have some returned items)

4- ReturnORDItems (detail of OrderItems which have...

I found...

The field {columns are not fields} where I am trying to insert is a UNIQUEIDENTIFIER and I am receiving the following error

Conversion failed when converting from a character string...

>> The requirement is to get the number of mutual friends between two users. This I need to do for a single user_name passed as a parameter. <<

UNH? Your narrative...