SQL Server :: Sum And Show Balance From Two Tables?
Jan 22, 2011
I have two table , how to sum and show balance ...
Table 1
ClientID Amount
001 100
002 200
003 300
001 400
004 500
001 600
004 100
Table 2
ClientID Amount
001 200
002 50
003 100
001 150
004 75
001 25
I need the result set like this Here Table 1 minus Table 2.
ClientID BalanceAmount
001 725
002 150
003 200
004 525
View 7 Replies
Similar Messages:
Jun 7, 2010
This is Table Stucture..
[Code]....
View 1 Replies
Apr 19, 2010
Im using asp.net 2.0 with Visual studio 2005... My requirement is i want to show my balance sheet from MS SQL 2005 database to graphical Chart... so Would u guyz will let me know the best high qulaity chat which support asp.net 2.0 with Visual studio 2005..
View 3 Replies
Aug 12, 2010
I have a web page that allows user to make transaction and they are allowed to choose if they want their transaction to be immediately transferred to the payee or for future transfer. I have problem handling future transfer, for an example, I want to transfer $100 to A on 12 August but today is only 09 August. So the amount should be deducted . I decided to make 2 balances; Available and Ledger balances. Available balance is the net balance after doing all the future transfers etc. but for ledger balance is what is available at the point of time. I'm thinking how should I form the query for the SQL statement. Currently, this is what I have. Transfer code = 2 -> future transfer
IF (@TransferCode = '2')
BEGIN
--Insert into the account transaction table first--
INSERT INTO ACCOUNTTRANSACTIONS (AccountTransID, CustID, TransDate, TransType, Reference)
VALUES (@AccTransID,@CustID,@Date,@TransType,@Reference)
IF NOT (@Date = Getdate())
IF (@Withdraw > @BankBal)
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 0)
PRINT 'INSUFFICIENT AMOUNT IN BANK'
SET @ReturnValue = 4
RETURN @ReturnValue
END
ELSE
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 1)
END
ELSE IF (@Date = GETDATE())
BEGIN
IF (@Withdraw > @BankBal)
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 0)
PRINT 'INSUFFICIENT AMOUNT IN BANK'
SET @ReturnValue = 4
RETURN @ReturnValue
END
View 1 Replies
Jan 26, 2011
We are currently running an asp.net application with 3.5 framework, using a SQL 2008 back-end. We have found that when we go from http to https we lose our session. Basically you come in on Server01 in http, add an item to your cart go to the secure checkout page (https) and you are now on Serve
View 2 Replies
Dec 30, 2010
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 Replies
Jan 8, 2011
im currently doing a web form that shows will show the contents of a table from a database... the problem is that the codes im using only shows the data from the 1st row of the table and i need the data from all the rows of the tables
using System;
using System.Data;
using System.Configuration; [code].....
View 6 Replies
Mar 17, 2011
I have just created an extra table named AccountDetails with four columns named AccNo,Balance,Transfer and UserId as foreign key to aspnet_userID primary key. I want to display users account and balance whenever the user successfully loged in.
View 4 Replies
Mar 3, 2011
I want to display opening balance in page header of the report.
ex :
opening balance :
aaaaa bb 340 2000.00
item brand qty amt
aaaaa bb 34 340
aaaaa bb 34 340
View 1 Replies
Jun 3, 2010
How do you currently find the balance between javascript and code behind. I have recently come across some extremely bad (in my eyes) legacy code that lends itself to chaos (someHugeJavafile.js) which contains a lot of the logic used in many of the pages.
Let's say for example that you have a Form that you need to complete.
1. Personal Details
2. Address Information
3. Little bit more about yourself
You don't want to overload the person with all the fields at once, so you decide to split it up into steps.
Do you create separate pages for Personal Details, Address Information and a Little bit more about yourself.
Do you create controls for each and hide and show them on a postback or using some update panel?
Do you use jQuery and do some checking to ensure that the person has completed the required fields for the step and show the new "section" by using .show()?
View 2 Replies
Apr 30, 2010
I have a control with a datagrid in it and I was wondering if depending on the value I get back from the a Request.QueryString if I could set the table name to that (that is the value being sent) and then have it build the columns?
I have about 3 different tables, and they have different amounts of columns, and of course with different names.
View 1 Replies
Feb 25, 2011
I am using asp.net2.0 , C#. I am binding menu control with sitemap to display menus and submenues. Which also restrict access and display of menu or submenu based on user's roles. I want to know Is it Possible to show/ Hide submenu based on sql tables with existing sitemap method
View 1 Replies
Aug 9, 2010
The problem is I had to create a draftResult class in order to show data that resides in two different tables using linq which means if i want to add or remove a column i will need to do so in the draftresult and in my linq. Here's what my setup looks like: I have two tables (draft, lookUpStatus)
draft table columns
idname,status id
lookupStatus
idtitle
public class draftResult {
public string draftName {get; set;}
public string status {get; set;}
}
I want to list the draft name and the status title in a table view. In order to do this, I wrote the following linq in a method in my sqlRepository class and return it to a IQueryable<draftResult>. My controller instanstiates the sqlRepository object and invokes GetDraftListing().
public class sqlRepository {
private Table<Draft> _draft;
private Table<LookUpStatus> _lookupubStatus;
public IQueryable<draftResult> GetDrafLtisting() {
return (from draft in _draft
join status in _lookuptatus
on draft.StatusID equals status.ID
select new draftResult
{
draftName = draft.name,
status = status.Title
});
}
}
The above process works but does not seem as flexible and i'm trying to get a better understanding of MVC and LINQ.
View 8 Replies
Mar 4, 2011
I have been trying to make this work for a while, but I have not been yet able to figure this put. I am using VS 2008 and mysql database. I wrote a query and checked to see if it works in database. It does.
I have a gridview, whose select command is that query. But for some reason, I just get all the rows from one table only. I rechecked my datasource and it is ok. I read on some discussions that it is NOT possible to have data from two tables in a gridview. Is that true? If that is not true, how can I have data from multiple tables in a gridview? Or any other web control for that matter.
View 6 Replies
Dec 4, 2010
have table COLLECTIONS and table CLOTHES.As an example, when showing the items on Listview, collection HAWAII
would be written on the top, and its texts and images on the itemTemplate.Then, collection WINTER and its texts and images on the itemTemplate.And so on.P.S: I´m connecting the Listview visually thru SQLDataSource, not programatically.How can i do it ? On the layout template using a JOIN on the SQL Statement ?
View 1 Replies
Aug 26, 2010
I'm seeking an algorithm to split a list of items of varying sizes into "N" number of similarly-sized groups.
Specifically, I'm working on an ASP.NET site in C# where I have a (database-retrieved) list of strings. The strings are of varying lengths. I have a set of columns which need to display the strings. I need an algorithm that will find the most balanced sets (item order is irrelevant) to allow the final columns to be as balanced as possible.
Abstracted Example:
Creating 3 columns.
Items to distribute:
- Item A - height 5
- Item B - height 3
- Item C - height 7
- Item D - height 2
- Item E - height 3
Desired output:
Column 1: Item A, Item D
Column 2: Item C
Column 3: Item B, Item E
View 5 Replies
Feb 27, 2011
As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
View 7 Replies
Aug 25, 2010
Using the [Code].... for server cache Dependency, to get a list of the tables that are enabled, We use the line below:
[Code]....
View 2 Replies
Feb 10, 2011
how to connect the two tables of the sql server 2008 databse in C#.
in this there are two tables
1) Tour header(id, name, city, destination)
2) Tour Detail(id, tour id, day no, title,description,images)in this id of tour header and tour id of tour header will be same.now i want to retrieve the data on the basis of when id==tour id.how can we can run the query of two tables.
View 4 Replies
Jan 24, 2011
There are more than 30 tables in my database.
I need to have a server log that will help to determine the number of items entered into the db and where those items are entered, without having query each table. It should be able to give me the average monthly volume of items input in SQL.
Can this be done using Sql Triggers or any other alternative?
I have to make sure that if I use trigger as the alternative I should have only one table to be updated with all the details of the Updates/Inserts being inserted into the Trigger table after the insertion into the original table.
Below given are some of the create table statements that I have for which I need to have a server log of the updates & inserts.
[Code]....
View 3 Replies
Feb 16, 2011
What is the best way to clean a database tables of data, and have the unique ids fields start at 1 again?
View 4 Replies
Jan 2, 2011
I want to get the data 4 or more tables. In such a way that all SubTable ID are present In the ParenTable.
But for some columns the Child ID are Null in the Parent Table.
Table1
ID
Name
SUBID
SUBSUBID
Table 2
SubID
nAME
Table 3
SUBSUBID
nAME
Values In Table 1 are like this
ID Name SubID SUBSUBID
1 A nULL 1
2 B 2 nULL
Want to join these tables and get the data from table1
View 4 Replies
Jan 11, 2011
Im using this script to flag if a record has been altered in two indentical tables :
[Code]....
Is there a simple way to check which fields have altered and update these fields (ie - add a *c* in at the start of each field)??
View 15 Replies
May 1, 2012
I have created an ASP web program on one server, when I move over to another server, all of the tables turn into lists, which is causing some problems. Below is my code on the original server
HTML Code:
class="right-col" /></div>
<span id="FFBFPrimaryLabel" class="left-col">Does your organization consider xxx?*</span>
<table id="RadioFFBFPrimary" class="right-col-radio" border="0">
<tr>
<td><input id="RadioFFBFPrimary_0" type="radio" name="RadioFFBFPrimary" value="Yes" /><label for="RadioFFBFPrimary_0">Yes</label></td>
[code]...
Basically I need to know how to prevent my code from changing my tables to lists, as you can see has happened above when i copied directory over to new server.
View 4 Replies
Nov 8, 2010
using sql server 2005 and vb.net 2005. I am writing a console application to import a mass amount of data from a non-sql database table into a sql server database table. The destination db table (sql server) has fewer tables than the source db table so I need to map the columns. does anyone have an example of how to do this?
View 1 Replies