Isn't jargon just a fancy word for slang? 😛

He means stripping the time directly in your query, rather than calling the UDF you posted earlier to do it for you.

Seankerr - can I ask why you're doing this? If you're just keeping duplicate data from existing in the table, it'd be better to add a constraint to the column.

(off-topic) Chris, curious, how are you formatting your code? Are you using something to help (I think I remember from other posts there's an add-on or something that formats it),...

The whole thing boils down to the stock market just being insane. The problem with the model, more data or no, is that trading is based on the perception of...

Here's a prettied-up version, commas, hyphenation and casing:

--============================================================================================

-- Create and populate a Tally table

--By Jeff Moden, 2008/05/07 http://www.sqlservercentral.com/articles/TSQL/62867/

--============================================================================================

--===== Conditionally drop and create the table/Primary...

All that good info, and the only thing that really jumped out at me was "the first half of 2010, which is 18 months away."

Dear God, I'm getting old ....

You're forgetting that all such courses have an agenda. Depending on the curriculum, the 'right' answer may change. If I'm teaching you about C++, then I'm going to tell you...

Just curious, if you are working in an environment where DBA's DON'T know not to use sp_, is there another way to filter out the system procs and keep the...

Ewan Hampson (10/9/2008)

---

Now there's a dissertation waiting to be written. Sounds like an anti-pattern.

I agree. Maybe a "good PM" simply...

ggraber (10/8/2008)

---

An article on this topic would be really cool, Jeff.

I just presented this concept at work using your split csv example.

I was just trying to think what other examples...

I'm sorry, is that one statement or two? 😀

Just curious Clint, if your date ranges are going to change, how are you going to handle the changes without using variables?

An article would be fun, I've already seen several uses I haven't tried yet.

Karthik, you were first to suggest it (within this thread anyway). You going to write us...

True, sorry, bad example. I was just thinking that it would be better to create the month names on the fly and sum up the amounts within the months...