Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER 2008 BIDS. Since SQL SERVER supports side by side installation of same/different versions (in fact we have BIDS 2005 & 2008 installed in a machine), I thought this should not… Read more

Recently I had to convert a report’s dataset, which was using Stored Procedure, into inline T-SQL commands. The dataset had 4 parameters , which it was passing to a stored procedure. I had to add two more parameters and since this was an emergency fix, I took the code from… Read more