DotNetJaps

For the ASP.NET,By the ASP.NET and Of the ASP.NET

Sponsors

News


My Another Blog

Browse by Tags

All Tags » VB.NET » SQL Server (RSS)
Previous week startdate and enddate in sql server 2000,sql server 2005
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)
Posted: Apr 26 2008, 11:10 AM by Jalpesh P. Vadgama | with 1 comment(s)
Filed under: , , , ,
More Posts