Hi Luis,

First of all, I'm sorry for the comments made that didn't help you on your task.

Second, you shouldn't keep something that is fast enough right now. You should...

ROW_NUMBER won't work on SQL Server 2000.

You could use a running total solution and the fastest is the quirky update. You can find different type of solutions in the following...

Eirikur Eiriksson (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

TomThomson (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a...

Oh my, so much work when ROUND function has a truncation option.

DECLARE @MyPay decimal(12,9);

SET @MyPay = 258.235543210;

SELECT ROUND(@MyPay,2,1)

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the...

HowardW (9/3/2014)

---

Grant Fritchey (9/3/2014)

---

Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause...

TomThomson (9/2/2014)

---

Sean Lange (9/2/2014)

---

In my experience nearly 95% of the people in this business...

Lynn's code is explained in here:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Alan.B (9/2/2014)

---

In this query this is what happens:

1. A is joined to B to create AB.

2. AB is joined to C to create ABC

Let's say you had 5...

You're lucky 😀

JackTimber (9/1/2014)

---

Hi all expert,

I am having some problem understanding joins (Specially left,right and outer apply)when it comes to more then 3 tables.

Like how are the result set formed , which...

Eirikur Eiriksson (9/1/2014)

---

Now he has put the bat aside and instead taken up the...

CELKO (9/1/2014)

---

NO! The column itself has to be scalar, not each value in a list, not...

CELKO (9/1/2014)

---

Please read any book on RDBMS. In...

You're welcome.

I hope that you've learned something from this. The main lesson would be that you don't need to count yourself because SQL Server will do it for you....