I'm still not receiving any at all.

Thought that might be related to the fact that I deliberately opt...

David Portas (4/26/2011)

---

GSquared (4/26/2011)

---

...

If the only way to avoid NULLs is to violate the very religion that is being cited as mandating that they are evil, then that's all I'm...

Steven993 (4/26/2011)

---

Well we have a problem here.

I think you didn't understand what 1NF is.

Let's take data example to make it clear !!

What you are citing are the properties a TABLE...

I'm not quoting me. I'm quoting Date. If you really think he doesn't know what 1NF...

Output doesn't really support full "select" syntax. But it's easy to get around that. Output into a temp table or table variable, then use that for your second...

Haiku would be fun.

Shakespearian iambic pentameter would be even better,...

[Jim].[dba].[Murphy] (4/26/2011)

---

Nah, you're not an idiot, just focused on the question at hand.

When the day comes when we meet in person, you'll know how stupid silly strange I really...

Try this:

SELECT DISTINCT

txn.Terminal,

txn.ActivityDate,

DATEPART(hh, ActivityTime) AS H

FROM...

I wish this did work that way. Learned years ago it doesn't, by making that same "mistake". I think what I did was try inline sub-queries instead of...

Here's the definition I'm citing:

According to Date's definition of 1NF,...

GilaMonster (4/25/2011)

---

According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get working....

T-SQL doesn't allow functions in exec statements that way. You can either pre-calculate the value and store it in a variable, then use the variable in the exec statement,...

[Jim].[dba].[Murphy] (4/25/2011)

---

That's probably because since you are so far away; it takes longer for the electrons to get there. They only...

Steven: You do realize that your address lines table violates 1NF, right? Rows are specifically ordered within the data (you even have a column for that), which Date says...

The "order by 0" piece just puts that first, before 1 or 2. It's just a way to sort the data based on more complex rules.

The IsNull part means...