Difference between second record and first record

Question

0.00/5 (No votes)

See more:

SQL-server-2000

Hi Dear,
Am writing a stored procedure and facing some problems.Plz help me out.

My Select Query is

SELECT LeftCount,RightCount FROM TM_Node WHERE Nodedate>=@PreDate and Nodedate<=@PostDate and AssociateId=@AssociateId

Where AssociateId is my PrimaryKey

Returning two rows.
The records of second row may be greater than the first one or remain same.

LeftCount RightCount
822 930
822 938

Diffleft = 822 - 822
DiffRight = 938 - 930

I want a query that will return me Diffleft as 0 and DiffRight as 8.

Posted 7-Jan-10 21:43pm

Member 3711336

Updated 7-Jan-10 22:51pm

v2

Add a Solution

3 solutions

Solution 3

Given that you've given one votes to the two people who tried to help you, and then rudely posted the same question again, I'm not sure why I'm still trying to help you. Now that I understand the question a bit better, the way to do this, would be to read the values into variables that you declare, then return their difference. Something like

declare @left1 int
declare @left2 int
declare @right1 int
declare @right2 int

Then

select @left1 = LeftCount, @right1 = RightCount FROM...

The hard part is, you need to figure out how to return left2 and right2 ( top 1 will return the first values ). Then you do

select @left2 - @left1 as DiffLeft, @right2 - @right1 as DiffRight

Posted 7-Jan-10 23:04pm

Christian Graus

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raja Soosai · Accepted Answer · 2010-01-07T22:28:00

Solution 1

Hi U can use cursors for to perform this task.

Posted 7-Jan-10 22:28pm

Raja Soosai

Christian Graus · Accepted Answer · 2010-01-07T22:28:00

Solution 2

wrote:
I want a query that will return me Diffleft as 0 and DiffRight as 8.

What do you mean ?

Posted 7-Jan-10 22:28pm

Christian Graus