27. August 2008 13:08
by Chakkaradeep
0 Comments
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]
18. August 2008 20:33
by Chakkaradeep
0 Comments
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]
16. August 2008 01:53
by Chakkaradeep
0 Comments
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]