|
||||||
|
|
“I got an ant farm; them fellas didn’t grow shit.” – Mitch Hedberg A few months ago I became aware that a company I deal with still uses dot matrix printers. For those of you who have never seen one, that’s because most companies phased these relics out of existence fifteen years ago. The dot matrix printer [...] Unfortunately M2M does not automatically populate the Country field on many screens when a US State is selected. This can cause problems in reporting when an executive wants sales broken down by country and many of them are grouped under Null. Anyway, if you want to see how many addresses are missing “United States” you [...] As I was preparing to post another script, this time with an update statement, I started to insert my standard disclaimer. However, as more and more of my posts will include SQL code, I thought I would just dedicate one post for the disclaimer and then link to it. So, without further adieu… Important: All information [...] One of my crappy college jobs was in market research. Yes, I was one of those annoying guys in the mall holding a clipboard. I would approach you, politely ask you about your soda preferences (for the enlightened folks we call it Pop), and then take you back into the “store” to do a taste [...] In the past couple of weeks, I have discussed the problems of orphaned records in the M2M Database and promised to provide a script to find them. So, I’ve decided to turn it into a game. If you’d like to play, paste the following script into your Query Analyzer or SQL Server Management Studio and [...] A Made2Manage customer called me with a serious performance problem with one of his custom reports. After I looked at it, I realized that the inventory changes in M2M Version 6.0 were the culprit. To give you some idea of his problem, the query in question ran took a few seconds before the migration and [...] Brief Summary – M2M orphans records in the Quote Master and Quote Items tables when the quotes are in the Cancelled status. As I mentioned last week, I came across a problem with orphaned records in my addressing tables. Rather than address my orphaned record problems piecemeal, I decided to create a script to check [...] Recently I got a call from another M2M Consultant who was attempting to install M2M on Windows 7. He simply could not get VBA to work. I asked him to run through the steps and I found his problem right away. He had made a mistake early in the process; I have made similar mistakes [...]
The Princess Bride The other day I found myself in a meeting regarding a CRM package we are implementing. The implementation company had brought two project managers, a sales lady, and a geek who will actually assist in the implementation. I sat in on this meeting with some of our executives and sales people. I [...] I found more orphaned records recently when querying a M2M table with an order by clause. Once again, this occurs because in my opinion the M2M database is not properly designed. Here’s a quick walk-through on how I found it. Incidentally, the screen shots are from TOAD using M2M’s practice database. A manager tasked me with [...] |
|||||
|
Copyright © 2010 Made2Mentor - All Rights Reserved |
||||||
Popular Articles