What's really amazing to me is that this thread has taken over 5,000 hits. D'ya s'pose anyone is actually learning anything for this? We can only hope.

Good chattin'...

What do you intend the CLR to do?

Heh... not trying to be a smart guy here... FEDEX overnight. Works great.

Yep......

Either that, or a partitioned view.

I agree... if you don't know a date, store it as a NULL and convert it in the GUI.

Some folks store...

Heh... not to worry... it's not as bad as that dummy that thought the sum of the differences between two points could be used to determine the closest point., 😛

Jonathan Kehayias (11/29/2008)

---

I'll never understand the attitude that I see people take, when the post a simple question and someone posts a BOL reference instead of just spoon feeding them...

rbarryyoung (11/29/2008)

---

Heh, I just assumed that you were leaving something...

rbarryyoung (11/29/2008)

---

try it like this:

CREATE PROC spWhichTable

@ColumnName varchar(50)

AS

SELECT o.name as [Table]

, c.name as [Column]

FROM sys.tables o

JOIN sys.columns c ON o.object_id = c.object_id

WHERE c.name =...

Nope... no digging required. That's basically what I meant but a whole lot shorter. 😉 Your good explanation is, of course, the most accurate... I was just trying...

Here hear!...

I find it's an unnecessary form of "ring knocking"... especially if you only have 4 visits, 1 post, and have never answered a question on the forum... then, it's just...

So you're saying that a derived table takes no memory?

rbarryyoung (11/29/2008)

---

Jeff Moden (11/29/2008)

---

What is true about triangles? The hypotenuse has a ratio to the sides no matter how long the sides are. You do not need to...