Tag Archives: functions

SQL Tricks – Remove Interior Spaces

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

Posted in MS SQL, Transact SQL | Tagged , , , , , , , | Leave a comment

Vigenere By SQL

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

Posted in MS SQL, Transact SQL | Tagged , , , , , , , , , , , | Leave a comment

Coding Vigenere Cyphers

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

Posted in Javascript, Swift | Tagged , , , , , , | Leave a comment

Using SQL to Mege Three Incomplete Data Sets

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

Posted in MS SQL, Transact SQL | Tagged , , , , , , , | Leave a comment

Output Buffers Are too Cool

All php developers have been there. You’ve got the page working just like it should. And with one exception, it looks good too. That exception: All of your status and debut messages. You hate to get rid of it. It’s … Continue reading

Posted in php, Web Apps | Tagged , , , , | Leave a comment

Find Nth Level of URL from Current Page

I ran into an interesting need when updating some code for MyQuizWiz, an online quiz and survey system that I developed. There’s a need to display content generated by the system in users’ Facebook fan pages.. Specifically, there is a … Continue reading

Posted in php, Web Apps | Tagged , , | Leave a comment