This week, I had a requirement to convert some HTML text in a SQL column to plaintext and store that plaintext in a different database. I found this solution for html to text, but it’s using a WHILE loop and … Continue reading
Have you ever had to collect a routing number and bank account number on a web form? I’ve worked on a lot of software where we collected this information (I’ve spent a lot of time on banking systems), but never … Continue reading
This week, I was given a set of data to import to a database. After the import, I noticed that the source data had lots of unnecessary spaces all over the place. I can, of course get rid of leading … Continue reading
After that previous post, I suppose it was natural for me to wonder what it would take to apply Vigenere cypher logic using T-SQL. I knew right off that the code would look much different. Mainly, because my self-imposed rule … Continue reading
Recently, I rewatched The Prestige, the very good Christopher Nolan move where Hugh Jackman and Christian Bale play rival magicians in the late 1800s. Jackman’s character has an old journal, written in cypher text that he slowly and meticulously needs … Continue reading
What happens if one part of your personality is data-parsing nerd and another part is music lover nerd? You end up trying to answer questions like, “Which songs did I have rated with 4 stars last year that are lower … Continue reading
A couple of weeks ago, I was called in to troubleshoot an error occurring in a SQL stored procedure. The procedure was selecting a variety of information out as XML data. The error occurred because on of the columns being … Continue reading
You can join data sets. LEFT JOIN, RIGHT JOIN, even OUTER APPLY. There’s nothing to learn here. Last week, I had what seemed to be a simple join of three data sets. My permutation was a lot more complicated than … Continue reading
I started a new full-time contract this month, which is always weird. Not having a full understanding of the project, access rights roadblocks, and unfamiliarity with the code base all team up to make days feel long and unproductive. One … Continue reading
Consider these two formulas in Crystal Reports:
|
1 |
if isnull({Table.Value}) or tonumber(Table.Value}) = 0 then "Rusult 1" else "Result 2" |
|
1 |
if tonumber(Table.Value}) = 0 or isnull({Table.Value}) then "Rusult 1" else "Result 2" |
One would think that these two should behave the same, right? In fact, the results are different if Table.Value is null. In the first case, “if isnull({Table.Value}) gets evaluated first. Since … Continue reading