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
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 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:
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 ?
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.
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?
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.
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 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."
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
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,
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.
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.
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?
