In one of our recent projects, we decided to swap SQL Express with SQL Compact to ensure easy installation on client machines…Though the move was smooth there was one hitch….SQL Compact does not support Stored Procedures!!! And here we were with lots of  medium  complexity SPs with Joins and GroupBys ,OrderBy and Min Max functions! […]