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
Category: SQL
Excel with Stored Procedures
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