Thanks for trying to make the table description at least... Though just empty rows isn't going to help us much I think?

Make it a poll instead... 🙂 I think 1 and 2 would be equal in performance (it seems that the same amount of rows are touched, and every row is...

So I think the @WhereStatement wasn't actually part of the INSERT. If you get used to put the SQL in a variable, understanding of using the quotes is much easier....

I agree that putting the SQL statement in a variable could have solved the problem, but I think I got it anyway. If you add an extra ') to the...

Without any tabel description, sample data and desired output, it's hard to guess where the problem really is.

You can use DISTINCT in Views, so that's not the problem....

henkvisser (1/16/2009)

---

I'm trying to use the stored procedure below in SQL Server 2000, but I get the following error;

Server: Msg 170, Level 15, State 1, Line 4

[Microsoft][ODBC SQL Server Driver][SQL...

Ken McKelvey (1/13/2009)

---

Try something like:

SELECT T1.[Order], T1.OpNo, T1.Operation

&nbsp&nbsp&nbsp&nbsp,DENSE_RANK() OVER (ORDER BY T1.[Order], MAX(T2.OpNo)) AS GroupID

FROM YourTable T1

&nbsp&nbsp&nbsp&nbspJOIN YourTable T2

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON T2.Operation = 'SETG'

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspAND T1.[Order] = T2.[Order]

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspAND T1.OpNo >= T2.OpNo

GROUP BY T1.[Order],...

MrBaseball34 (1/12/2009)

---

SELECT e.EncounterID, SUM(ed.Balance) as TotalAmt

FROM ptEncounterDetails ed

INNER JOIN ptEncounterEncounterDetail eed

ON eed.EncounterDetailID = ed.EncounterDetailID

INNER JOIN ptEncounter e

On e.EncounterID = eed.EncounterID

WHERE TotalAmt >= 5.00 AND

...

One thing I run into with such problems is fragmentation.

Aam (1/12/2009)

---

It is a good question though. You'd assume the data type that uses more bytes for storage would have a greater 'precision' both ways of the decimal point.

Strange...

I'm still too attached to my VB way of thinking, so...

In a New Query box in SSMS... So in the same place as where you have the query. So in SSMS,...

Last of the 3 questions all the options were true... I hope to see some questions where none or only 1 option is true... I'm going to click them all...

UPDATE #Results

SET @PrevCum_Sal = Cum_Sal = Sal + @PrevCum_Sal,

@PrevName = Name --Just an "anchor"

FROM...

Thanks for the input, though there were some flaws in it that made it a bit unclear what is desired exactly. Here I changed the input a bit, let me...