I Want to Punch Bill Gates 
SQL Server seems like it would be important enough to be mostly bug-free, but I came across what I think it a rather major flaw in the reporting services.

I tried to use this function to set a field.

=IIf(IsNumeric(Fields!Data.Value), CDbl(Fields!Data.Value), Fields!Data.Value)

Simple, right? If the value is a number, then turn it into a number so I can use numeric formatting methods on it.

If it's not a number, then just leave it alone and display it.

Does it work? No. It fails because SQL is too stupid to ignore the statement that should only be invoked if the condition is met.

If the data is not numeric, I get an error because SQL tries to do the CDbl conversion anyway.

Here is my solution:

=IIf(IsNumeric(Fields!Data.Value), CDbl(IIf(IsNumeric(Fields!Data.Value), Fields!Data.Value, "0"), Fields!Data.Value)

Clever? Maybe. It certainly illustrates how stupid SQL is being.

Now where's Bill???

[ add comment ]   |  [ 0 trackbacks ]   |  permalink
It's Tough Being a Leafs Fan 
Suddenly the Leafs are entertaining again. The last two games were great fun, but I think the real question here is this:

How much can they hurt themselves, while still leaving us without playoff hockey?

Last year it was a single point. They did as well as they could, getting as poor a position in the draft as they could muster, without actually giving us any playoff excitement.

This year they're within 5 points and driving to get closer.

Actually making the playoffs is once again a pipe dream, but it seems they're all about shooting themselves in both feet at the end of the season, once thoughts of post-season play are out the window.

Way to go, boys!

Of course, it's not really their fault at this point in the game. We want them to win. But what about Cliff Fletcher? Wasn't he brought in to get all their ducks in a row so the team can improve for the future? After doing much of nothing at the trade deadline, shouldn't he at least be sending people to the minors to bring up some newcomers for experience? Shouldn't he be playing 3rd string goalies to give them a taste of the big time? Isn't his job to make them lose now, while the players do whatever they can to win?


[ add comment ]   |  [ 0 trackbacks ]   |  permalink
I learned something today. 
A cafe mocha is delicious.

Mixing a packet of hot chocolate in with a cup of french roast coffee is not.

[ add comment ]   |  [ 0 trackbacks ]   |  permalink
I don't like Carl Edwards 
I don't like Carl Edwards. I think he's NASCAR's version of Eddie Haskell. He smiles when he knows the cameras are on him, and puts on a good show for his sponsors, but I have little doubt he wouldn't step on your head if he thought it would benefit himself in some way. I'm sure Matt Kenseth knows this as well as anyone.

With that in mind, I give huge props to Mark Martin for taking him out of the Nationwide race on Saturday, whether it was on purpose or not. Nobody expect he'd do it on purpose, but I have to wonder. Does Mark Martin like Carl Edwards?

Way to go Mark!

It's just too bad nobody could do the same thing in the Sprint Cup race yesterday. I could only hope he'd fall on his head during his smarmy backflip after the race. No such luck this time around, and hopefully he won't get another opportunity.

On another note... Jimmie Johnson... what the hell??? I'll definitely be thinking twice before picking you for my fantasy team again in the near future!


[ 2 comments ] ( 11 views )   |  [ 0 trackbacks ]   |  permalink
My Predictions for the Gatorade Duels 
Here's what I think is going to happen tomorrow afternoon.

Jimmie Johnson will win the first race, with Dale Jr. pushing him to the front to return the favour from Saturday night.

Without Jr. to drive around him, and with Jeff Gordon pretty much on his own out there, I think Tony Stewart will take the checkers in the second race. Of course, if Mikey lends a hand to Jr's new teammate, the Duels could end up swept by Hendrick cars.

That would be very discouraging for the rest of the NASCAR stables!

I'll save any predictions for the 500 until after I see how everyone performs tomorrow.


[ 1 comment ] ( 12 views )   |  [ 0 trackbacks ]   |  permalink

Back Next