Tag: reports

Creating a Ship-to Report in SQL Server Management Studio

The company I work for is approaching its 10th anniversary this year. In that time, we’ve accumulated a variety of ways of getting data out of the system. For a ship-to report, I can run a couple variations from the N screen, or via Access through some of Carol Brown’s near-magic. And I have a …

Continue reading

Your first MSSQL Report, ‘Flushed Today’

A few weeks ago, I had quite a few orders go sideways on me. The orders that were a mix of wholesale product and items we stock were missing our stocking items from the deliveries. With a little investigation, it seemed the culprit was likely that tickets had been prematurely flushed to status B. As …

Continue reading