April 28, 2006 at 2:23 am
I have a simple question, or at least I think so... From time to time you need a pivot table that lists for example all numbers between 1 to 100 or all dates within a year. Is there a SELECT - SQL statement that can handle this?
SELECT...
Creates a table:
Column1
=======
1
2
..
..
100
Thanks in advance!
/Mårten
April 28, 2006 at 3:35 am
April 28, 2006 at 4:51 pm
I'd like to do a minor threadjack here, assuming the question was answered to the submitter's satisfaction, and ask "why?"
I have a purely theoretical question, not related to any particular product.
Let me elaborate: I've read Celko, who otherwise is like HWMBO for me, and several others on this, but I'm trying to get convinced that this is such a good idea. A sequence table and a date table, I mean. Can someone try to convince me? Perhaps I'm missing something.
(I am honestly not trying to be a troll; I would like the best arguments out there, to help convince me.)
I'll say that I am absolutely not a beginner in this realm. I've been working with relational theory for a long time. I'm a Programmer (note the capitalization) and have been properly schooled on relational math and theory. My knowledge is perhaps dated sometimes as I graduated in 1988. (and I'm still trying to get used to the JOIN statements for non-OUTER JOINs and I'll NEVER use the UPDATE..FROM statement (non-standard), but that's another thing.) But Math is Math.
So you can use big words and everything and I'll understand them like a big boy.
Thanks. No, really, thanks.
// your ordinary, everyday relational purist.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply