GET NEXT Months of Todays Date in sql

-
Next Month

(select dateadd(m, 1, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)))

Next Month  + 1

(select dateadd(m, 2, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)))

Comments

Post a Comment

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

-
Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control  Byte[] imgbyte = null;  if (FileUpload1.HasFile)             {                 string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);                 FileUpload1.PostedFile.SaveAs(Server.MapPath("~/UserPhoto/") + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName);                 photo = "UserPhoto/" + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName;                 string fpathPhoto = Server.MapPath(photo);                 FileInfo fInfo = new FileInfo(fpathPhoto);                 long numBytes = fInfo.Length;                 //Open FileStream to read...
Read more

Get Running Sum of Query SQL Query

-
 select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where  IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName
Read more
-
Image
G H RAISONI INSTITUTE OF BUSINESS MANAGEMENT HAS ORGANISED PINNACLE 2014. THAT INVOLVES PROGRAMS LIKE POSTER PRESENTATION, IT QUIZ , C & C++ PROGRAMMING CONTEST & COMPUTER GAMING COMPITITION.DATE WILL BE ANNOUNCED SOON.
Read more