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

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
-
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