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
I was notified that a little-used application within my organization had begun displaying an error instead of allowing the users to log in via Citrix. This ActiveX control, which was integral to the operation of the application I was servicing, had come from a very old version of Crystal Reports. Apparently, someone had recently installed … Read more
In my last post, the problem I experienced was with an old application (which I’ll call “App #1”) written in PowerBuilder 6.5, and accessed via Citrix. Today, a similar type of application (“App #2”) is the source of the problem, and the fact that it’s being moved to the same new server made the cause … Read more