Another thing I would suggest is to minimize the use of special characters in database and object names. Instance names you can't always avoid having special characters (\ for example)....

Anyone who still uses text variables should be shot, especially because it makes me read the question wrong.

Jayeff (4/22/2009)

---

mike (4/22/2009)

---

Hey! Not fair. I lost a point because of a missing ORDER BY ? Like a previous poster mentioned, both 1 and 2 are correct. :crying:

Can I get...

You can write a whole library about this.

Yes, use PK's in your joins, so you can use their indexes. This is pretty much a general rule that applies for...

Hrm, why did I do left 4!

No! Yes! .... Maybe? should be a third option then... As what a former poster said, it sounds like SQL Server has a female intuition inside 🙂

I like these questions a lot more than making 'SQL puzzles', just by showing bad code. Your question is a typical sample of what I run into daily. Every DBA...

What you have read is correct... Adding columns into the middle of the table is quite fuzzy and out of database technical view not needed. However, many people tend to...

I think the correct query would be to add the GROUP BY of course, and also ORDER BY 3 DESC. Or name the derived item, and order by that name....

LOLOLOLOLOL!!!

If it makes you feel better to keep insisting on how (fill in the blank) everyone else is, while you are superior in every possible fashion, by all...

If I were you, change jobs so you can be fully a C# developer. If we may believe you, SQL will be obsolete in a few years anyway.

Ha, I guess I was too slow answering, or I didn't read the whole thread first...

Both statements work for me in Access:SELECT '"STICHTING WERELDHULP-BELGIE"'

SELECT """STICHTING WERELDHULP-BELGIE"""

Were you trying...

Explaining what you're trying to achieve sounds like a good idea... Along with DDL and sample input. Since I don't know what you're trying to do, the only thing that...