Tell me about it. We had a German teacher (i.e. teacher...

Thanls for the feedback so far. Apologies, the GO and Drops were an omission but I hope that didn't detract too much from the meaning behind the question. It's the...

Nice question - I thought they would all be the same size as well.

WayneS (11/11/2010)

---

GilaMonster (11/11/2010)

---

WayneS (11/11/2010)

---

Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all...

Hi Biren,

Something like

SELECT Brand,URL FROM Table

UNION

SELECT Model,URL FROM Table

UNION

SELECT Category,URL FROM Table

UNION

SELECT ColorCode,URL FROM Table

should do it. Are you concerned about the order of records?

ronmoses (11/16/2010)You shouldn't complain about people who complain about spelling on the part of people who complain about describing questions as "nonsense." Too many nested complaints will make your...

At the interview you should hold out for the 5th highest salary. This will give you...

tommyh (11/16/2010)

---

Richard Warr (11/16/2010)

---

You shouldnt complain about spelling. This is an international site and as long as you can understand what someone else writes... its okay. Perfect spelling/grammar is rare....

I thought it was an interesting question as well - currently more people have it wrong than right which shows that we can still be surprised at the "behind the...

Sometimes, as was the case with your query, people put an alias after the server.database.schema.table construct. That's why you see "TASKS", "STAF" and "TIUSER" there twice in succession. Yours isn;t...

Hi David,

Sure, the tables used are:

Database: TRACKIT_DATA

Schema: dbo (that's the default)

Tables: TASKS, STAF and TIUSER

James Goodwin (11/9/2010)

---

Steve,

Re: Fingerprint reader

How hard do you think it would be for someone to create a copy of one of those fingerprints and use it to log on to...

W!OW34f34D3h54qo looks like a nice strong password but it's just SQLServerCentral moved "one key up" when you type it in. Use that method in conjunction with a memorable phrase (like...

pitvax (11/4/2010)

---

Yes ... if I remember well 🙂 at 17 November 1989 there was big demonstration in Praha and several days after I was standing at main square in Pilsen...

It will be to do with data types. You need one of the operands to be non-integer to get this to work. Try this:

SELECT 665/12

SELECT CAST(665 AS MONEY)/12

..and you'll see...