Dag nab it! I knew there was super duper secret agent style forums out there! It's where questions are answered before they are even asked by the SQL...

What a bunch of Alecs! Yes - the smart kind!

😛

I'm taking that as well, but before the end of June. I have to get 70-432 taken first though. Am running out of...

Awesome! Sean, thank you!

🙂

OK - what if I need to make certain that there isn't just 1 space, but say 2 or 3 or 10 spaces? How would I incorporate LTRIM and...

Hi Sean - thanks for the reply. So just use your line in-between my final WHEN and before the ELSE?

I typically don't either, but when your awesome employer is paying for you to take it - it's kinda hard to hide!

:blush:

thanks for the encouragement all. I have been using the MeasureUp testing, and in all honesty - that was better than my Microsoft Press book. I'll be good...

I just took my 70-432 test today, and am sorry to report that I am still just an uncertified newbie.

:crying:

but the good news is that I know what...

Becoming a DBA is the greatest experience of your life! There is sooooooooo much to learn and do! Why ANYONE would want to leave the database engine behind,...

😛

😀

🙂

Grrrrrrrrrrrrrrrr! I'm a flippin' idiot! Gail - I told him to tell me what he had defined the DECIMAL type as in his PROC, and sure enough -...

It's funny you mentioned the RECOMPILE option - I asked him about that, but found out that we are using 2005 and not 2008 (so I'm going to get slammed...

P.S. Gail, your blogs are always awesome! I had him look that over first, but I still think it's something with our logic that is throwing this off....

Just one last followup to this thread...

My developer is still running into one additional issue with this logic. In his PROC (as he is testing it out), he is...