Few other professions are so clearly led by marketing people. The surgeon, for example, who eyes you up whilst fingering a scalpel doesn't often get his expertise and advice from...

My gut says the two are unrelated. As far as I can tell, spt_values is just an old EAV type lookup table/view...

For anyone interested in MS building such a function into T-SQL, please see the following thread.  It used to have 278 votes until MS moved the "Connect"...

They do go out...

For anyone interested in MS building such a function into T-SQL, please see the following thread.  It used to have 278 votes until MS moved the "Connect" system to...

No, I'm not saying that at all. "All collies are dogs but not all dogs are collies"... While it is true that all objects with an object_is < 0 are...

Using "OPTION (USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION'))" instead of "OPTION(QUERYTRACEON 9481)" looks like it may be the answer. I need to do more testing before closing the question but I did want to...

sys.all_objects should in fact be the UNION ALL of system objects (sys.system_objects... object_id < 0) and user objects (sys.objects... object_id > 0).

If you are seeing something other than this, please...

Thanks Jeff,

I don't know that one version has an inherent advantage over the other. I just think it's interesting to see alternate solutions to problems.

Jeff,

Kudos on another excellent article. It's always interesting to see your take on these types of functions.

For comparison, here is an altered version of a similar function I created a...

• This reply was modified 5 years, 4 months ago by  Jason A. Long.
• This reply was modified 5 years, 4 months ago by  Jason A. Long.

Please give this a read and follow the advise on how to post a question.

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Snippets are your friend......

Fewest number of bytes so far, as well.  If you want to go real short, convert to the first of the month and store it as a DATE....

You can also use a computed column for as_of_month, there's no need to physically store it again. as_of_date date NOT NULL, as_of_month AS CONVERT(varchar(6), as_of_date, 112), That column...