Community Member Profile

Recent Blog Comments By randy b

• Translate Microsoft SQL (MSSQL) To MySQL

  Posted on Apr 17, 2008 at 12:30 PM

  Here is a nice summary of MS SQL temporary tables and table variable types. They are different. http://www.sqlteam.com/article/temporary-tables #tblname are local temp tables ##tblname are global temp... read more »

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Mar 29, 2008 at 8:53 AM

  We tend to try to look what the users need today and then what will they ask for next and in many cases we end up doing what I call data staging - ie: the king of data duplication - We have a large data warehouse of transactional sales and deliveries (SAP ERP data). Our reporting interface is all... read more »