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

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

how to subtract value at previous row from current row

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

column1   Column2

1                1

2                1

10              8

20             10


Thanks & Regards, PSWASULE

View Complete Post

More Related Resource Links

Set Field in Current Item to a previous version's field value

When using SPD, can you make a WF condition to set a field's value to it's previous version's value? Versioning is turned on for this doc library, but checkin/checkout is not on. These WF's run only after creation and editing, so I need to set a value back if a user doesn't have permission to set a choice column field to specific values. Thanks in advance, Chris

How to Correlate Last weekday of previous Month and First Weekday of current Month ? - T-SQL 2005

Hi friends, below is my detail description. I woulld like to show busines users Previous Months Last Weekday in Drop Down List as a Parameter. Now, if they select Previous Months Last Weekday, then i need to pass First weekday of Current month. How can i correlate this things ? if you need more information, let me know.   Thanks.

Compare current with previous data

I need to compare the current price to an old price and not quite sure how to approach it. I am bringing in 3 CTE's that contain all of the data. Then # the bottom I'v got effective dates but I'm not sure how to re-write this and compare current prices to the old price that was effective before. The DNC Column is the column i have to compare in the last query
declare @dt datetime
set @dt = getdate();

With itmlvl as (

How to remove weekend days from current row date and Previous row date ?


column0    Column1                     ResultColumn

1              Mon, 07/12/2002           0 days

2              fri, 11/12/2002              4 days

3              mon, 14/12/2002           1 days

Thanks & Regards, PSWASULE

How to show previous page total in current page?


I have a problem that I want to show total of previous page in current page.

I have a table that I show sum  of page in page footer. but i can not show that in next page.

I tried any way but I can do that in reporting service 2008.


Please help me as soon as possible.


Assign value of a current field to the value of a previous field


I am trying to assign a value to a row based on the value of a field in the previous row. In this case, I am able to identify where first left character of the item number of the previous row is 5. When this is true I need to display the value of the meal_typ field in each succsessive row until the condition is met again. So far the only thing that I have managed to do is pass the value to the first line.

I'm just not sure how to approach this issue. Perhaps there is a way to set a field in the main query equal to the result of the case in the subquery? Or perhaps there is a way to assign a variable to the subquery and set another variable equal to it in the main query? I haven't been able to make it work yet but I believe that there must be a way.

I am not able to use a stored procedure for this because I need to post this in our ERP systems "sql query requester" which does not recognize references to a stored procedure.

Here is the query i am using now and a sample of the current result set:

select cur.line_nbr, cur.item_nbr, cur.meal_typ, 

(select case when left<

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Retrieving a variable from a previous page



I'm looking to have a search page where a user will select an item from a listview, then then taken to another page that wil display data based on their original selection.

A user will type in a string and be presented with a list of usernames that are like that string, when they select a user name who's profile they would like to view I would like the page that they're taken to, to be that users profile.

How would I transfer the variable from the search page to the profile page, and when I work on the profile page, how can I access that variable?


Users getting logged out because HttpContext.Current is null


We've  been trying to fix this one for a couple years, and I'm just out of ideas, so any help is really appreciated!

We've got a fairly large, complex web application that uses Forms Authentication to authenticate users.  Throughout the application we store and retrieve information about users in the Session object, and in some cases in cookies.  In a couple places we check for the existence of the context, and if it's null we send the user back to the login page to re-establish the session. 

Just a quick run-down of this web app: C#, .NET 3.5, IIS 6, ASP.NET State Service to manage session

As for the session timer, we use our own home-grown timer, which is basically a client-side timer, which is backed up by a check to the SQL database to see when their last activity was.  This seems to work well for us.  It's not perfect, but it allows us to notify the user before the session times out, and allows us to be certain we're not logging a user out before their 60 minutes of inactivity is up.

What's happening is that certain users are being logged out after just a few minutes.  We've eliminated the timer as a cause and believe what's happening is the HttpContext.Current is null, so the user is logged out.  We do not know why the HttpContext.Current is null, and I underst

Registering controls of current assembly object reference NOT set error


Hi There,

I have created a simple ASP.net Web Application (2.0) and have added a web user control.

Now in my page I have added this control but I have registered like this,

<%@ Register Assembly="WebApplication1" Namespace="WebApplication1" TagPrefix="Custom" %>

Which means I want to access all the controls in my current Web Application project

Then I have added my user control like this,

<Custom:MyUserControl ID="MyUserControl1" runat="server" PublicProperty="Hello" />

Every thing is fine but when I execute the project, NO control on my user control gets "instantiated" and thus I receive error "Object Reference Not Set"

Note that My Control has,

1) Public property PublicProperty as String

2) 1 Label control

In Load Event Handler I am setting Text property of Label Control to PublicProperty. Here object reference NOT set error occurs (which means Label control is NOT initialized).

I don't want to register my control using Src, TagPrefix etc. Any ideas?


Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!


           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

How to get the current directory of msi is running from?



I Created a setup file with Custom Actions.

How can i get the Current directory of msi file is running?

for ex:-

I copied my installer on Desktop and installing.. in this case my current directory would be desktop location

Any Help would be Greatly Appritiated!!

Knowing the event occured in user control in current page




      My web application has user control which uses third party controls called Devexpress controls. The user control is a menu  and is part of the Master page. It is placed there because this needs to be available in all the pages. My user controls raises a even on item clicked. Now, My question is that Is there any way to know that the event has occurred in page_load of the current page in which I am in?

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Display 'Top Queries Over Previous 30 Days' to users


In the Site Usage Reports, there is a section for 'Top Queries Over Previous 30 Days'. I would like to display this information to users. 

Is there a existing webpart for this? 
Is the data stored in a list that can be used for this purpose?


Steve Clark

Creating a gridview to allow editing of current users


I finally got membership and roles setup and seems to be working.

I have setup a page to allow the creation of a user and editing of roles for a user.

I would like to setup a page with a gridview that displays all users and what roles they are assigned. I remember running across someone else that was looking to do the same thing, but cant find it. Not sure if it was in this forum or online somewhere else.

But i found that i can use the  aspnet_Membership_GetAllUsers procedure in my db to get all the users, but how can i add the roles to each person and possibly setup the gridview so that each role they have, is displayed on their row in the gridview

So i would like to see something like this maybe more data displayed depending on the client request.

Username                 Email                 Last Login                          Roles

meofcourse               m

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