The Conditional rounding is not giving the desired results, based on the statement

That would imply an OriginalValue greater than...

game_outcome

Game over. Human player wins in 40 shots! With just my Patrol boat left. Phew :w00t:

I was going to suggest UNPIVOT but then noticed it's in dwains signature.

Phil Parkin (8/12/2013)

It's because Excel thinks it knows what you want: so that even when you...

Thanks a lot for that. Saved hours of head scratching and throwing things at the monitor 😀

Thanks for the explanation Wayne.

Learned something new and another place to look if results don't meet expectations 😉

hmm, I get

Msg 213, Level 16, State 1, Procedure Proc2, Line 4

Column name or number of supplied values does not match table definition

SQL 2008

Win 2008 R2

As with Cliff, I glanced over the important bit.

I must read the question completely.

I must read the question completely.

I must read the question completely.

I must read the question completely.

.

.

.

Be aware of the QOTD from the 5th July

http://www.sqlservercentral.com/Forums/Topic947263-1694-1.aspx

Sometimes even with cash registers people will struggle if you were to give them 20.47.

Picture didn't appear for me either.

That's just plain wrong. 😉

Good question and good explanation by Hugo.

Ah well. Got it wrong but at least learned something new.

Hours worked last week 0

Nice holiday 😛