> I have some case statements that are 10 lines long per statement Inspired by Stephen Russell's huge blocks of SQL (and as a cheap shot way to re-ask my SQL analysis utility post from yesterday from a different angle), how do you manage your huge blocks of SQL?
By manage I mean format, pretty print, version, audit, comment, re-use, etc? And when do your blocks of SQL become so large that you need to re-factor them by creating re-usable views/tables and/or using a different tool (Informatica, etc). Thanks, Malcolm _______________________________________________ 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.
