August 10, 2012

A better way for record set storage than SQL, what is it?

     What's your way to record set storage by SQL? any better way than SQL? yes, esProc.
      Firstly, count the employee in the R&D department;
      Secondly, count how many employees of Sales department is more than that of the R&D department;
      Thirdly, find out the discrepancy in the average employee ages between the R&D and Marketing departments.

SQL solution:



esProc Solution: