http://www.sqlservercentral.com/articles/Basic+Querying/ansijoins/189/

nice (if old) article on types of joins.

BTW CROSS JOIN is not the same as FULL OUTER JOIN.

SET NOCOUNT ON;

CREATE TABLE Table1(

...

I do this all the time but my theory is a little weak. This is an example with TWO tables.

SET NOCOUNT ON;

CREATE TABLE Table1(

ID int IDENTITY,

Description varchar(32),

ItemID int);

INSERT Table1...

My daughter bikes to work until the snow starts in Pennsylvania. I'm in New Orleans and probably could bike to work - it's only 7 miles - if it...

What version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.

I give - what's it mean?

The first sentence looks like "Be unwilling to arrogantly cause injury"...

Eric, you have a legitimate complaint. I had forgotten about the syntax error -I fixed it and blew on by when I was doing my test run. I...

Your problems with cut & paste are not the author's fault. Everything I copy from a code block gets smooshed into one long line, even Jeff Moden's beautiful code....

Pardon my grammar. Last sentance should read: "..but probably would have forgotten about it if others hadn't made such a big deal. "

When I started following this site a couple of years ago, I would have LOVED to have seen this article. It is very basic, yes, but it is a...

I'm using IE7 on WinXP Pro 2002 SP2, all patches applied. Over half the code blocks in this article come up as a horizontal scroll bar only - no...

Looks like the editor "ate" most of your code blocks. 🙁

What does the XCOPY command look like?

From the sample data, it appears that department and team have a one to many relationship: one department can have many teams but each team has exactly one department. ...

Proably is overkill for "SELECT * FROM"

I use SQLServer Management Studio templates for things like:

SELECT c.Description as Clinic, a.ApptDate,

p.NameLast + ', ' +

COALESCE(p.NameFirst,'') + ' ' +

COALESCE(p.NameMiddle,'')...

Clipmate, the clipboard-extender program I use, does that. You can evaluate it for 30 days, but then you'd have to buy the program.

We work with medical data so we CANNOT have copies on our local machines for developement work.

I wrote a series of scripts to obscure our data. I...