LSAdvantage (3/18/2013)
Thank you for the very detailed explanation Craig! That is exactly what I need. That pivot query was very, VERY helpful.
If it makes you feel any better, I typically have scripts saved (somewhere) of my bitvectors to do exactly that. I usually work with bit patterns more than single flags so it can get complex fast. Think 'skorts', which are skirts and shorts (from the 80s?). Either you can combine the flags skirt and shorts and consider it a different value, or not. Depends on how you want your search conditions to work.
I was able to see how when I added up the Value in PeriodTypes where the bit was "set", I could come up with the PeriodType value in Reports. So I added 65536 to the "Overall Performance" row in Reports and now I see "Calendar - Year To Date" as one of the options!!
Dead on target. Another reason that flag values tend to be used, just FYI, is because front end checkbox lists just LOVE those things, and can pass you those values. Under most circumstances a human should not be involved in these values, you want an interface to them.
I am so grateful for this forum and contributors such as yourself!
Thanks for the complement, and I agree, this forum has pulled my tail out of the fire once or twice as well. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA