Today I downloaded RhinoMocks and referenced in my test project (Microsoft Visual Studio Testing Environment) and executed my unit tests. My tests failed with the same error (for all tests). Visual Studio was kind enough to find that the RhinoMocks.dll which I downloaded is not trusted and cannot b... [More]

Today I had the need to have optional parameters in my SQL stored procedure. And It wasn't that complex to implement :) Below is the code: ALTER PROCEDURE [dbo].[GetSampleRequests] @Org varchar(50), @Type varchar(50), @From DateTime, @To DateTime AS BEGIN &nb... [More]

Recently I had the necessity to do cross-tab report with the SQL Server data. First thin that comes into everybody's mind is to use the PIVOT functionality in SQL Server. But, being a programmer, I am not that fluent in writing and managing complex queries. I was looking out for some .NET implementa... [More]