Hi great qod!

Here's a tip:

Move the decimal point to the left by the negative number and then do a regular ROUND(d, 0). Applied to this it ends looking like...

Good question!

Hugo Kornelis (8/9/2010)

---

...I thought there would be a very high percentage of correct answers since the confusing default lengths for character strings have already been covered in a few...

Hi nmeseth,

OK first: you are right that it has everything to do with parent-child dims.

Quick answer - try the following: put .DATAMEMBER after members that belong to parent-child dimensions like...

I guess now would be a good time to point to a great post by PaulWhiteNz about UDFs and SCHEMABINDING which I can not find right now. My read performance...

Would missing and unused make it 10?:)

I'm curious did you test and find that using non-persisted columns was faster than pre-calculating and storing all the permutations that you needed? (I guess it would probably depend on...

...And off it goes posted unfinished (sorry about that).

I think it might be a good idea to have a peer-review of ones Q and A before submitting a QoD to...

Now this doesn't hold true:

I am very pleased that UMG developer made a thorough explanation in the previous comment as it was exactly my...

This could make the Q "less confusing" but less real-life and interesting:

DECLARE @Testvar VARCHAR;

SET @Testvar = 'Red';

print @Testvar;

If only there was a remark of the collation set (as UMG developer...

Jamie Longstreet-481950 (7/17/2010)

---

Could call it a trick... in another form:

select * from(

select 'red'

union select 'red'

union select 'blue'

union select 'green'

union select 'yellow'

union select 'orange'

union select 'purple')x

where textfield like 'red' ...

Nice question. I got it right cause I made an effort to examine all kinds of default parameters after encountering something similar. Not 100% sure but I think the rule...

The following code was the cause of the error:

Syntax for CAST:

CAST (expression AS data_type [ (length ) ] )

Syntax for CONVERT:

CONVERT (data_type...

I second that. Personally, giving the wrong answer highly motivates me to...

Hi all!

Maybe the following code example brings some light on the above statement....

If I need to quickly disable all triggers in the database then I use disable trigger syntax to take care of all tables and views and then append disable trigger...