SQL Server :: Sum Value Of Previous Rows + Exisitng Row?
Mar 11, 2011
I had a sql statement to prepare dataset for generate staff overtime work and time-off balance.
SELECT Table1.staff_key,Table1.from_date,Table1.to_date,Table1.total_min ...... FROM Table1
UNION ALL
SELECT Table2.staff_key,Table2.from_date,Table2.to_date,Table2.total_min ...... FROM Table2
the output of the sql statement should like this:
From To No. of hours
total_min Balance
01/01/2011 12:00 01/01/2011 17:00 7 hr 0 min 420
420
07/03/2011 12:00 09/03/2011 14:00 ( 2 hr 0 min ) -120
360
07/03/2011 19:00 09/03/2011 20:30 1 hr 30 min 90
450
10/03/2011 17:00 10/03/2011 17:30 ( 0 hr 30 min ) -30
420
But I have no idea how to calculate the Balance in the sql statement that it will sum up the total_min of previous rows + existing row.
View 6 Replies
Similar Messages:
Aug 7, 2011
I am trying to build myself a grid that displays some very simple data (a name and a price of food items on a menu) which the user can very easily edit. The idea is that the grid is always editable, and editing, deleting, adding a new row and hopefully swapping two rows can be done without posting back to the server (at all, not even in an update panel or something).
So far I managed to get deleting to work, but it requires a bit of an explanation. I have a pretty good idea of how to implement adding new rows so I will try that myself. The problem at the moment is swapping rows.
First of all, the data I am displaying in the grid are instances of the MenuItem class, which has properties:
Id (integer, unique identifier)Name (string)Price (float)
I'll explain this step by step:
Saving updates
The grid is a GridView with 6 rows: ....
View 2 Replies
Apr 11, 2014
I have a table where each month I need to find the SkipUtgang value of current month (ex: 779) and the value of SkipUtgang in previous month (ex: 788); then Sum the two values; and finally multiply the result with the number of day of current month (ex: 31). as example, I have the below table:
How to script the SQL for this scenario?
View 1 Replies
Jul 26, 2010
I am developing a web application in ASP.NET3.5 with C#. I also using Telerik RadAjax Control. When user click the menu then open the page with a new tab(Like web Browser).I want to create, when user back any previous tab(page) the will be show the previous data without loading 2nd time( like browser tab). Is it Possible ?
View 2 Replies
Aug 18, 2010
I was looking for such an SQL query that it will give me the first 20 records but it will skip the first 10
There are some LIMIT and OFFSET stuff with MySQL and Postgres but what works with SQL Server?
View 2 Replies
Mar 24, 2011
[Code].... Save previous row value to next row?
View 8 Replies
Sep 25, 2010
i would like to query out the next record and previous record guid from the current record guid.But i don't want to use the ID + 1 or ID - 1 because the ID is not secure for query like this. I am using MS SQL.
May i know how can i write the sql query?
View 2 Replies
Mar 25, 2011
how to make it?? How to read next row and previous row in database / SQL
View 5 Replies
Jan 5, 2011
My table is :
ID Dated
-------------------------
1 2010-01-01 00:00:00.000
2 2010-02-20 00:00:00.000
3 2010-09-15 00:00:00.000
4 2010-04-03 00:00:00.000
5 2010-11-09 00:00:00.000
6 2010-12-11 00:00:00.000
7 2011-01-18 00:00:00.000
Now I want to find(select) Id and dated columns which have a difference of 4 months(less or greater than) from previous ID (row).
Expected Result
ID Dated
1 2010-01-01 00:00:00.000
2 2010-02-20 00:00:00.000
6 2010-12-11 00:00:00.000
7 2011-01-18 00:00:00.000
How to do this.
View 1 Replies
Mar 23, 2011
If I have records in a table in this order:
Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0
Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?
View 9 Replies
Sep 12, 2010
I would like to calculate a compound interest for each row based on the previous row.
My table Table1 :
index sum quantity sum_after_interest
1 100 5 500(??)
2 500(??) 2 1000 (??)
3 1000(??) 3 3000 (??)
I marked in question marks the columns that I want to calculate, where I only have the sum for the first row and the quantity for all the rows.
Can this be done using views and inner joins or nested selects ?
View 1 Replies
Aug 2, 2010
I'm using a wizard control with 4 steps, when I use the previous button to navigate back to the previous step the page reloads but at the bottom of the page.Instead of showning the whole of the page, the user views the footer of the site and the previous button and next button.I'm sure there is a very simple answer to this but I just can't figure out how to get the page to reload to the top.
View 8 Replies
Sep 4, 2013
I am using ASP.Net AjaxControllTookit Tab Container and I have 9 tabs , on each tab panel i have some asp elements and a "prev" and "next" asp buttons. How to navigate next or prev on these asp buttons clicks.
I already try the c# code :
TabContainer1.ActiveTab = TabContainer1.Tabs[2];
View 1 Replies
Jan 5, 2011
I am having problem while using onclick="javascript:history.back();" with Aspnet. In the first page i filled some data and click search button it show some results, i click on particular result for its details which navigate to the 2nd page but when i click on custom back button it refresh the page and all data set to initial values,when i use onclick="javascript:history.back();" I get nothing but the page displays "webpage has expired."
View 1 Replies
Jan 23, 2011
Actually I have a gridview with many rows and I want to insert the all rows in sql server through one store procedure first row can inserted but what should we do for other rows
View 3 Replies
Jan 10, 2011
How can I combine multiple rows into a comma-delimited list in sql server in build function?? in HCL
examples :
X
---
12
15
18
20
Output : 12, 15, 18, 20
with in build function of sql server.
View 6 Replies
Jul 27, 2010
i want to select rows between 15 to 30 from sql server so i am writing this:SELECT uid, nname, nemail, ntelephone, naddress, ndate, uname, upassword, usertype, umonth, nregistration, regdate, paydetail, servicetype, serviceperiod,
View 4 Replies
Aug 30, 2010
Recently i have come across one question in sql query
Question: Which SQL Query helps to view the TOP N rows From the particular SQL table?
View 3 Replies
Feb 10, 2010
i want to select rows between 15 to 30 from sql server so i am writing this:
SELECT uid, nname, nemail, ntelephone, naddress, ndate, uname, upassword, usertype, umonth, nregistration, regdate, paydetail, servicetype, serviceperiod,
View 3 Replies
Nov 8, 2010
Below is the code for adding the value in a table, but the problem it is adding in one row only... how can I make it write the value in all the rows?
INSERT INTO Tools (SiteID)
VALUES (1)
WHERE Quantity = '1'
View 4 Replies
Oct 21, 2010
I have a table having the columns of (ID StartDate EndDate)
how can i retrieve the ID's of all the rows when a date passed is in between the startdate and enddate.
View 3 Replies
Nov 13, 2010
This is how my table in db looks like
Remarks Id Remark
1 Rem1_aaa
2 Rem1_ccc
1 Rem1_bbb
2 Rem1_ddd
i want the output as:
Id Column1 Column2
1 Rem1_aaa Rem1_bbb
2 Rem2_ccc Rem2_ddd
View 4 Replies
Mar 11, 2011
I have a large database of user profile data. I need to be able to compare 1 row against all of the other rows, for all columns to find the best match.There are around 30 columns of data for each row. I need to be able to find the 5 best matching rows.
I.E.
Row 1 matches on 2 column's
Row 2 matches on 12 column's
Row 3 matches on 7 column's
Row 4 matches on 4 column's
Row 5 matches on 9 column's
Row 6 matches on 23 column's
Row 7 matches on 29 column's
In the end it will show me the data for rows 7, 6, 2, 5, 3 Now to make it even harder, Some of the columns are bit, some are varchar.Some of them may be a direct match, some will need to search if the column for row2 contains the text of row 1.
View 6 Replies
Sep 29, 2010
I am having trouble deleting three table rows using SQL. The middle table is a junctional table allowing a one to many relationship between table 1 and table 3.
Table 1
Order_Id int Primkey FK1
Name Varchar
Date Datetime
Table 2
Order_Id int PrmKey FK1
Item_Id int PrimKey FK2
Table 3
Item_Id int PrimKey FK2
Description Varchar
Price money
Acually, I want to delete all rows associated with any particular order.
View 3 Replies
Jul 24, 2010
I am accessing rows in an SQL database table based upon the contents of the Primary key and another column. But, I cannot insert new rows in the table when the content of the new Primary key column already exists in another row. Can I define the table with a multiple column Primary key so that a unique value can be based upon the content of both columns?
View 3 Replies
