Do you have any other...

I think that is exactly what Lynn has suggested above.

This might help you

; WITH PRODUCT1 AS

(

SELECT*, DENSE_RANK() OVER( ORDER BY P.PARENT ) AS RN, 1 AS Lvl

FROMPRDST AS P

WHEREP.PARENT IN ( 1055874, 1055872 )

UNION ALL

SELECTPR.*, PR1.RN, PR1.Lvl + 1

FROMPRDST...

You will need a CTE to achieve the results

DECLARE@table TABLE

(

IdINT,

NameVARCHAR(10),

Value1INT,

value2INT,

PreviousRowId INT

)

INSERT@table

SELECT1, 'A', 10, 0, 0 UNION ALL

SELECT2, 'B', 0, 5, 1 UNION ALL

SELECT3, 'C', 0, 6, 2 UNION ALL

SELECT4, 'D',...

tknecht 32495 (5/21/2013)

---

Sorry for the confusion. I'm obviously not an expert.

The searching I've done for doing what I need suggests using an update statement to add information...

The result you want is exactly the same as what you have.

Why are trying to update it or am i missing something?

Something...

lmacdonald (5/21/2013)

---

That is correct, -1 0 or 1 depending on the previous value compared to the current one. It is working correctly, I just am not processing why I'm...

It would be...

shohelr2003 (5/21/2013)

---

2. Nope, log is not always 87% empty. I monitor it regularly, it becomes like for example 58%, 35%, 12%, 1% free. Then I take log backup and becomes...

You can use a CTE to do this

; WITH PRODUCT1 AS

(

SELECT*

FROMPRDST AS P

WHEREP.PARENT = 1055874

UNION ALL

SELECTPR.*

FROMPRDST AS PR

INNER JOIN PRODUCT1 AS PR1 ON PR.PARENT = PR1.CHILD

)

SELECT*

FROMPRODUCT1

Great you could find it out 🙂

eklavu (5/21/2013)

---

Are you pulling the top first record? No t sure if I understand clearly.

TOP (1) should be in your main table not on the derived table "sgn"

SELECT TOP...

SELECTmth, qty,

SIGN( S1.qty -

(

SELECT TOP (1) qty

FROM dbo.Sales AS S2

WHERE S2.mth < S1.mth

ORDER BY S2.mth DESC

/*

This query is part of your SELECT statement

It will always return a single value

That value...

from members_.memberID_ with (nolock)

Do you have a table named memberId_ which belongs to the schema members_ ?