If you use NEWID there are two problems: the GUID is 16 bytes (which is a potential problem as it is a lot of strorage if the table is big)...

Basically your problem is that you are using the country derived from MG_OFFICE instead of the country derived from your fixed list. You could try something like

select booking...

Just in case MMartin1's reference wasn't enough:

Changing the database default collation has no effect on existing columns in existing tables, only on new columns (columns in new tables created...

Chine

+1

Actually I clicked 2 (query and namespace) and then noticed that clicking the second cancelled the first because there was...

Maybe you are misreading him - that "finally" could refer...

masochism

Useful question.

I find the documention on this is utterly awful, almost incomprehensible; so getting it right was quite a surprise. I wouldn't have been at all confident if I'd...

Hugo Kornelis (8/6/2014)

---

Fair enough. Let me try it differently.

During the parse phase, a single pass is made. For this phase, the line "DECLARE @i int = 1, @j-2 int =...

Hugo Kornelis (8/5/2014)

---

I see that Tom already posted an explanation. I think he is correct, but I will phrase it simpler - my explanation is that a variable is available...

David Webb-CDS (8/6/2014)

---

The other thing you are leaving out is the vendor ecology. RDBMS technology and SQL had great success partly because it provided a consistent data manipulation method...

I don't think it's documented. And of course it's slightly more complicated than that,...

Defense

peter.row (8/6/2014)

---

In typical SQL style actually the answer is "it depends" - on how you work.

Hovering the mouse may be quick but not that helpful since as soon as you...

The 6 points raised in the first post of teh series are all a bit boring/mundane and don't, for me, address the title (which in any case is ambiguous) at...