Prediction: Despite being featued prominiently in an episode of "Big Bang Theory", no one will buy data breeches, and millions will be returned unsold to manufacturers. Apple will scrap...

D'oh... never mind <post deleted>

I just ran into this today. Saw a post from "UserSmith" on http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/64fbddf0-8990-482b-add5-28a2e677c109. While this "UserSmith" claims the answer is somewhere in the post at http://sqlblog.com/blogs/mosha/archive/2005/06/30/how-to-check-if-cell-is-empty-in-mdx.aspx,...

Extremely useful! Thank you, thank you, thank you!

Microsoft included a stored procedure with SQL Server 2000 called "sp_MSObjSearch" that did exactly what you're proposing to do. It's parameterized so that you can choose what type of object...

Thanks for the responses. That's an interesting note regarding numeric keys I was using concatenated text keys. I'll keep that in mind for next time.

I worked around the issue...

Anyone? Beuhler?

Excellent point about the index scan, Jeff.

I'm wondering with the new expresssion, if the date that the query is run is 2008-05-30 13:25:23.723 and the expiry value is 2008-06-04...

A possible issue - maybe minor, maybe not depending on your user needs:

Getdate() returns a date time stamp including hh:mm:ss.000.

This is not an issue if your expiry column...