Category Archive: SSMS

Mass-changing customer records

Mass changing customer records is one of the most powerful, and dangerous, functions in DDMS. Here’s an example of a simple mass-change.

Continue reading »

On prefix changes and favorites lists

For Q4 of 2014, United made the decision to align their prefixes with Lagasse’s, as United feels “Lagasse is the standard in jan-san.” Wisdom of that decision aside (hint: I didn’t find it particularly wise), it left a whole lot of dealers with some work to do.

Continue reading »

A New Ship-To Report, From a Development View

Early in the days of bendustries.co, one of my first posts was an introduction to SQL Server Studio Manager and the basics of SQL queries, using a basic ship-to report as an example. Since then, I’ve expanded a bit on what I run as a ‘typical’ ship-to report. Aside from that, I think the time …

Continue reading »

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 »