Category: SQL

I’ve heard for many years that using SELECT * FROM <some table> is a bad idea.  I’ve always agreed with this in principle, but in practice often haven’t followed this guideline.  That’s all about to change, as I was caught out by what (in my opinion) is a bug in Microsoft SQL Server that totally… Continue reading Why I Never Use SELECT * FROM

Introduction A couple of week ago, I read this post by David Poole about reading data from SQL Server into Excel, where the data source was a parameterised stored procedure.  David concludes that a small amount of (albeit trivial) VBA code is required in order to make this work.  However, deep down in my psyche,… Continue reading Excel with Stored Procedures