Did you look into ROW_NUMBER function (assuming you're using SQL2005)?

Please provide table def and rsample data in a ready to use format. For details on how to do that please see the first link in my signature.

Furthermore, your code...

Ok, here's what I came up with.

It is imporant to understand the quirky update concept as well as the requirements that need to be fulfilled. So, I urge you to...

Kingston Dhasian (3/2/2010)

---

Check if this works..

SELECT*

FROM cElements A

LEFT JOIN sectionList D ON D.sectionID = A.sectionID

LEFT JOIN fList E ON E.fID = D.fID

WHERE

1 = CASE

WHEN '2006' IN(SELECT ...

ashok_raja (3/3/2010)

---

Hi

Apoligize for the confusion..

Here is what I want

ID CODE Value Volume RunningTotal Average

1 ...

No it's not. And yes, it is.

Like with any other tool/command/feature: if used wrong, it will...

To give an example of Adi's great explanation regarding the right place for the right tool:

If you'd need to send 3 or 4 parameter to a procedure, then a comma...

There's not only the person who's posting such data. There are people around in almost each and every forum who realize that those data seem to be real/production.

So we should...

ashok_raja (3/2/2010)

---

Hi,

Actually 46 will not be there as the next row will be for different ID

i.e

Insert into dr_temp(ID,Code,Value,Volume) Values(

2,'120',31,2311)

if present then Yes! it matches, I think Let's get the...

It depends.

Usually, a SQL query will rely on some logic requirement(s). If both results are possible,...

Why not joining the temp table directly to the query?

Something like

SELECT *

FROM cElements A

LEFT JOIN sectionList D ON D.sectionID = A.sectionID

LEFT JOIN fList E ON E.fID =...

It still is not really clear:

But it also falls in the range b/w 179646 and 560329. Why not use that one?

Jeff Moden (3/2/2010)

---

nathan 7372 (3/2/2010)

---

Thats the funny thing about decimal places. Technically, you are both right. Obviously Jeff's higher precision datatype leads to a more mathematically accurate answer....

Would you mind elaborate the business case?

Especially the part

Why do you compare the median...

What exactly are you trying to do here?

Your "CASE WHEN '2006'..." (and all other similar case statements) don't really make sense. What variable/column is supposed to have a value of...