Out of the box, Reporting services does not handle divide by zero conditions gracefully. There are plenty of posting on how to use the IIF() function to accomplish this, with some rather horrific looking code. In order to simplify the coding process and make the resulting expressions readable by a mere mortal, I wrote the […]
2006-07-28 (first published: 2005-05-26)
3,983 reads
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
I received the following notification a few hours ago. It seems legit but has...
Hi, Need your help. I've a SP that is using Update statement on a...
I have query which is filling TEMPDB I need suggestion how to modify this...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers