I’ve been upgrading an old Sybase PowerBuilder 6.5 app to a much newer version, SAP PowerBuilder 12.6. During this little adventure, I’ve had to update much of the hard-coded SQL code that was originally written for SQL Server 4.2, and was later upgraded to SQL Server 2000. This application’s database had been running on SQL Server … Read more
I really like the LIKE operator! (See what I did there?) I use it on a daily basis. It does have one frustrating shortcoming, however. Unlike the IN operator (where a list is used for comparison), you can only compare one pattern with each LIKE statement. If you have only a few patterns, this isn’t … Read more
Finding duplicate rows in a table is quite simple. Deleting only the duplicates – as opposed to deleting all rows that have duplicates – is a bit more complicated. I have a table variable called “@Readings” with the following schema: First, I load the table with data from another database on a linked server called … Read more