-
Execute Stored Procedure From Excel With Temp Table
Do you want to execute a stored procedure from Excel? No problem! Does your proc contain a temp table? Problem! Actually, don’t panic. The fix is incredibly simple. Tracking down this post was probably the most difficult part. When executing a SQL Server proc with a temp table you must remember to “SET NOCOUNT ON”…
-
The Three Best Tips For Effective Code Reviews And Preventing Knife Fights!
Bring a group of senior business intelligence professionals or SQL Server pros together to review each others code and you have all the potential for a good knife fight. As our team is getting ready to make design/code reviews a regular part of our development process we’re looking to make sure we get off on…