.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

combine amtpaid for matching bill

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

I need to update my table to consolodate the amtpaid for each billnbr. I have these fields billnbr,invnbr,line and amtpaid.

What I would like to do is make the amtpaid for each billnbr(group by) reflect a total for each invnbr. When I'm done the table
will look like this.

    zb1234,50168,1,4234.50  ( the amtpaid for 50168 and 50169) all lines will have same values just different amt per Invnbr











View Complete Post

More Related Resource Links

Combine two datasets matching on group names?


Have a "how would I accomplish this?" SQL query question for the gurus in the group....

I have a table that I need to query against for a "report". The report wants to see "counts" style data broken up by year and grouped by company divisions. Something like this:

Line of Business     2009       % of Total          2010         % of Total
Parent Group           54              40%            56                42%
- Sub Division A        4               3%             3                 3%
- Sub Division B        1               1%            

Combine, minify and compress JavaScript files to load ASP.NET pages faster

Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

Is this load full or matching one only... coz of need to know performance



This my Two Table i have one doubt...

For my first table i have select Top 2 from Employee_info 

and second table itz just selct * from MDEp..

What my doubt is on loading the above report?

Is this load all the record from MDep or just matching one based on Employee_info..?

The Polyglot Programmer: Mixing And Matching Languages


See why you need to be a polyglot programmer and what mixing and matching languages can do for your projects.

Ted Neward

MSDN Magazine March 2009

SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier


Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007

What Gives You the Right?: Combine the Powers of AzMan and WSE 3.0 to Protect Your Web Services


In this article, Niels Flensted-Jensen demonstrates how you can combine new and existing Microsoft technologies with minimal new code to provide flexible authorization for individual Web service methods. Windows 2003 Authorization Manager, Web Service Enhancements 3.0, and Enterprise Library all play a part.

Niels Flensted-Jensen

MSDN Magazine November 2005

Web Services: Increase Your App's Reach Using WSDL to Combine Multiple Web Services


The very tools that have helped drive the growing adoption of Web services, and the enabling abstractions that they provide, can often prevent developers from peeking behind the curtains at the XML standards that make up the Web services stack. This article will offer a solution that enables type sharing between proxies created for complementary Web services, while at the same time providing an opportunity to examine the Web Services Description Language (WSDL) and its interaction with the Web services tools you know and love.

Gerrard Lindsay

MSDN Magazine March 2005

ASP.NET: Combine Web and Windows Services to Run Your ASP.NET Code at Scheduled Intervals


If you want to schedule ASP.NET tasks, one solution is to use a Web service to provide an interface to your ASP.NET application and build a Windows service that calls to it at scheduled intervals. Thus the ASP.NET application doesn't have to own the scheduling logic. Here the author shows how to schedule your ASP.NET tasks using a Windows service to initiate the Web service call because Windows services can start themselves when Windows boots up.

Andrew Needleman

MSDN Magazine March 2005

No Results matching your search were found. WSS 3.0


I've got one sharepoint 3.0 site, which is a hostNamedSiteCollection which won't return any results when we search it - searching the entire site or a single list both produce the same "no results matching your search were found".
The site uses Windows Authentication.  We have no Alternate Access Mappings set up. It is regular HTTP
I've added test content to other sites housed in the same Web Application and searched - that new data is appearing in the results.
I did a backup using STSADM and restored the site to my dev server (as both a hostNamedSiteCollection & a regular site collection) - searches return results just fine.
I deleted the site from the prod server and restored it (into a different content database even!) from a backup  I made with STSADM - no results are returned.
I restored the site to the same web application as a Standard site (http://webapp/sites/sitename) (NOT a host named site collection) and results ARE returned.

I've looked at the trace logs & application logs on the server, but can't find any errors that I can tell might be related..

This is the only site I've ever seen have this problem.  We have plenty of other hostNamedSiteCollections and search is working fine on them.


Matching set of characters via regular expression

I need to be able to match sets of quote and space characters in a string and replace these accordingly. I currently have this done in 2 lines of code, but would like to use regular expression so that I can use only 1 line of code. See below: var Qt = unescape("%22"); //quote char var Sp = unescape("%20"); //space var Cr = unescape("%0d"); //carriage return var Lf = unescape("%0a"); //line feed var CrLf = Cr + Lf;  //carriage return & line feed stringOut = stringIn.replace(Qt+Qt+Sp+Qt,Qt+Qt+CrLf+Qt); stringOut = stringOut.replace(Qt+Qt+Sp+Qt+Qt,Qt+Qt+CrLf+Qt+Qt);   I want to replace space in string like in pattern below with carriage return line feed: (in hex) 22 22 20 22 or 22 22 20 22 22. This needs to return 22 22 0D 0A 22 or 22 22 0D 0A 22 22   Line in green above will only match and replace 22 22 20 22 , but I want have regular expression into 1 line of code which  will match and replace either 22 22 20 22 or 22 22 20 22 22  

SELECT statement to return NULL by matching data from another table.

Hi,I am fairly new at SQL and I have been struggling for days now trying to find an answer to my problem and i have come to the point where i have run out of ideas and about to give up. I'm hoping someone can put me in the correct path. The problem I have 3 table Table 1 Department" has the following columns: REF, NAME Table 2  "Department_Collection" has the following columns: REF, DEPARTMENT_REF, MANAGER_REF, STORE_REF, ACTIVE Table 3 Store" has the following columns: REF, NAME, STORE_ID  What i am trying to do is to take all the rows in the Department table and get a matching row (DEPARTMENT.NAME, DEPARTMENT_COLLECTION.REF) from the Department_Collection table, if it does not match any then still display DEPARTMENT.NAME but mark DEPARTMENT_COLLECTION.REF as null. I have tried the following select statement but it seem to remove all null values when supplied with a 'storename' SELECT DEPARTMENT.NAME, DEPARTMENT_COLLECTION.REF FROM DEPARTMENT_COLLECTION right outer join DEPARTMENT on DEPARTMENT_COLLECTION.DEPARTMENT_REF = DEPARTMENT.REF left outer join STORE on DEPARTMENT_COLLECTION.STORE_REF = STORE.REF where STORE.NAME = 'storename' order by DEPARTMENT.NAME   Any help will be greatly appreciated. Thanks

Inline Editing No Matching Records - No Insert

Hello.  I have been using Inline editing in Sharepoint Designer 2010.  Is it possible to have the insert link displayed even when there are no matching records?  The Default view shows edit, delete, and insert links.  But, the No-Matching Records template doesn't.  I think I can use Newform.aspx for the first record instead, but would like it to operate the same way for inserts as it does when there are records.  Thanks

Limiting Nickname / Phonetic matching to just First Name

The Nickname / Phonetic matching in SharePoint 2010 is a nice new feature, where searching for Jeff will pull up results for Geoff, Jeffrey, etc. However, it also searches surnames and pulls in people with a last name like Jefferson, Jeffery, Jeffrey When creating your query, is there any way to limit the nickname searching to just the forename? If I do a queries like "FirstName:Jeff" or "FirstName=Jeff", then it stops doing nickname/phonetic matching. I've also tried "Nickname:Jeff" and "FirstNamePhonetic:Jeff", but these do not pull up any results at all. How does the nickname/phonetic matching work internally, does it search over a number of internal field names (if so, can these be searched using the advanced property search such as FirstName:Jeff). I thought perhaps I could get the kind of search we need by combining it with logical operators, so if I want any person with a first name sounding like Jeff, and surname beginning with B, then I could do this...   LastName:B* (FirstName:Jeff* OR Jeff) ...but the Jeff on it's own without a Property name Prefix causes a Malformed Query error, I assume it cannot be applied with Logical Operators. Changing the query to...   LastName:B* FirstName:Jeff* Jeff ...brings results, but the wrong results we want as the query does not pull back people with a Forename of Geoff, presumably

Wild Card Best Bet Matching

Is there a way to use wildcards in the keywords used in the Best Bets configuration?

Percentage of matching days off among employee's

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday). I want result in percentage.result like thisConsistency Days of assignment            Across 4 weeks            3 weeks                2weeks                0                                                             2%                                   0%     &

Combine two tables

I have two tables: tInv containing invoices. The fields I am interested in: id cusid ' customer id source ' invoice# dtjournal ' invoice date And tSal containing orders (not billed/shipped yet) with the fields: id cusid ' customerid salnr ' sales order number dtsalordr ' sales order date I need to query these two tables and return a single table ordered by date, containing: id,cusid,number,date,type ('in' or 'so') In other words I need to select id and cusid from both tables and dtjournal and dtsalordr from either table and combine into one column 'date' and get source & salnr and combine into 'number' I want a list, ordered by date, of all invoices & orders. Is this a possibility with a SELECT statement or do I need to fetch both tables, and then manually move the rows into a new table?   Thanks, Erwin

Combine two queries in one resultset

Hi,I want to combine two queries like :select name as name1 from table1 where id = 6 and select name as name2 from table1 where id = 2.I need a single resultset. How can I do that?Regards,ap.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend