Browse by Tags

All Tags » VB.NET » SQL Server (RSS)

Zip operator in Linq with .NET 4.0 by Jalpesh P. Vadgama

Microsoft .NET framework 4.0 is having many features that make developers life very easy. Its also provides some enhancement to Linq also. I just found a great operator called Zip which merge the sequence of two entities. Here is the explanation of Zip...

Previous week startdate and enddate in sql server 2000,sql server 2005 by Jalpesh P. Vadgama

Following are the some tricky code to find previous week startdate and enddate in sql server 2000/2005   Set @STimeStamp=GETDATE() set @PStartDate=@STimeStamp-DATEPART(dw,@STimeStamp)-6 set @PEndDate=@STimeStamp-DATEPART(dw,@STimeStamp)
More Posts