var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Char(4) or integer for Year / Quarter Field
what's best for year resp. quarter Field, char(4) resp. char(1), integer or other?
Both are part of a composite index.
what does "resp." mean?
best for a numeric year like 1937, 2007, etc. is SMALLINT
best for quarter (1-4) is TINYINT
Why not combine them both?
SMALLINT as 20074 (yyyyq)
this will work upto year 3276 and quarter 4.
why not? because how would you pull out the rows for 2007 that way?
that's why not combine them
That's why :-)
Originally Posted by r937
resp. = respectively , isn't it?
I thought this could pull all records for 2007
Col1 >= 20071 And Col1 < 20081
but then again, I might be wrong.
yes, that works, but it's clumsy
now show me how to get all the rows for the 3rd quarter only
clumsier and clumsier!!