His task was to update a data source from a Web Service system that is out of our hands, in our company data in SQL Server.
He did this on his own this AM and after lunchtime he was happy to show me old school down and dirty code. I let him explain away and then commented out most of what he did and replaced it with a join of the data objects that he had already generated to start his code with. Checked the count to see if any substitutions were done and then iterated the joined set for any differences. I am now going to look to see if I can get a better query to exclude identical data between the objects so we can focus on the diffs, which the task was all about. This task was only about a Category type list of 60 rows. I see this being awesome when I have thousands in the near future. I'll post the how to next week. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
