select

a.COLUMN_NAME_1,

b.COLUMN_NAME_2

from

TABLE_1 a

join

TABLE_2 b

on a.TABLE_1_ID = b.TABLE_1_ID

order by

a.COLUMN_NAME_1,

b.COLUMN_NAME_2

There, was that so hard?

Good developers produce easy to read, easy to follow code. Bad developers produce unreadable, hard to follow code. ...

Patrick Seegers (6/9/2010)

---

[font="Courier New"]Hello,

I have found storing the date as an integer to be useful as an integer surrogate key to a date dimension table with attributes you can not...

They will be populated with...

Use the DATETIME2 datatype in SQL Server 2008.

If SQL Server is conveting a string to DATETIME, there are only 2 unambiguous formats that SQL Server will always parse correctly:

'YYYYMMDD HH:MM:SS:mmm', example: '20100617 15:46:59.997'

'YYYY-MM-DDTHH:MM:SS:mmm', example: '2010-06-17T15:46:59.997'

Any other format...

When you negotiate, you have to make sure you're talking to someone who can actually say yes.

If they told you boss that he can't approve raises, then he doesn't have...

It doesn’t sound like you’re getting the run-around any more, just news you didn’t want to hear.

The first rule of negotiations is to continue working towards a deal. Even...

Transaction logs on a USB drive? That's got to be one of the worst ideas ever.

If you really have to use one, use it for your backups.

Wayne West (6/13/2010)

---

There's a reason why I like also having the old Query Analyzer from SS2000 still around, I just wonder how much longer it will work with future versions...

Just because you enjoy something doesn’t mean you should do it for a living. Work has a way of making things not fun.

For many years, photography was my hobby....

When you have critical servers down, the importance of a DBA becomes obvious.

We have around 500+ database servers and thousands of databases spread across many locations, so hoping for the...

PaulB-TheOneAndOnly (5/20/2010)

---

That's not true. There is a Microsoft published...

If this is something you are still working on, there is a fairly extensive discussion of the techniques for defining the square around the circle on this thread:

Great Circle Distance...

paul.knibbs (5/19/2010)

---

Another good reason for not using the One True Lookup Table is the lack of flexibility. Your requirements right now mean that all those different lookup types have the...

meichner (5/18/2010)

...I have limited experience with this, so I guess I also have limited vision as to the problems. I am not sure that I understand the 'two column'...