Category Archives: Uncategorized

I have a customer that I track the production of every Stock Code that is processed through the Production Floor.  This is done outside of Syspro via a custom program.  The issue they have run into is that Syspro users … Continue reading →

I was looking for a single query that will snag a field, update it and return the new value.  I stumbled across the OUTPUT clause. Dim Sql As String = “Update ArControl Set NextCustomer = Right(’0000000′ + CONVERT(VARCHAR,NextCustomer + 1),7) … Continue reading →

FLOOR(DATEDIFF(day,DOB,GETDATE())/365.242199)

We had a project that required reading data from within the contents of a PDF file.  After some research we found ABCpdf from webSupergoo that works as advertised. (HS-PDFWatcher)