September 2008 Entries
I found another oddity that seems to be undocumented today. This one in SQL Server 2005. Apparently, you cannot start objects (at least stored procedures) with the word "Log". I have a table called ShipNoticeLog and a stored procedure called LogShipNotice. The table is the noun and the stored procedure is the action -- this is how I prefer to do the naming. My code quickly failed with the message, "Invalid object name 'LogShipNotice'..." I ended up solving my issue by renaming the stored procedure...
My EDI project is plodding along as planned. We flirted with the possibility of having our VAN do the translation after a couple of issues came up: Customer provided a shorter than expected deadline Customer increased the number of forms required However, at the end of the day the VAN didn't look like they could deliver the forms in the alloted time and the customer decided they weren't ready for the deadline -- they're phasing their vendors in different waves. Based on all of these criteria I am...
I got an interesting project today. Not only does it look to be pretty fun, but it should be a challenge and give me a chance to learn something new and add another thing to my resume. The project is the implementation of a solution to pass off EDI documents through a VAN to one of our customers -- of course more customers will follow. The customer is only dictating three forms 830, 856, and 862 which are material releases, advanced shipping notices, and shipping schedules respectively. My solution...