Try the following:

Open Query Editor (or whatever the name was back in SQL 2000... I simply forgot). Highlight the word "sysobjects" and press {F1}. IIRC it will open the...

I don't...

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....