Also, could still use an explaination of what the function is attempting to accomplish.

Fixing the math should be the easy part. I didn't really look at what the calculation was doing, I just wanted to be sure I returned results close (and...

Without the DDL (including the collation for character fields) a little hard to determine where the problem is with the code.

What is portnumber? This column isn't defined in the table variable and isn't used in a subsequent query of the table variable.

GSquared (8/10/2009)

---

John Rowan (8/10/2009)

---

I just wanted to say that from an outside observers perspective, that I admire Lynn and Gus's continued professionalism in the face of what has ended up...

In addition, could you explain what this function is attempting to do?

I have a problem with your code. The following table variable has two columns with the same name.

declare @lTable TABLE

(

ID numeric(10) identity,

ID varchar(50),

area_Code varchar(50),

country_Code...

Could you provide the DDL for the table and put the sample data into a format that can be readily consummed to load the table? Please read the first...

The only problem with the WHILE LOOP solution is scalability. Test it against a one million row table and you'll see what I'm mean.

Tim Walker (8/10/2009)

---

Lynn Pettis (8/10/2009)

---

oli (8/10/2009)

---

Paul White (8/10/2009)

---

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have used. ...

oli (8/10/2009)

---

Paul White (8/10/2009)

---

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have used. I would encourage everyone...

Not having Standard Edition available I'd say to do some testing. It is possible that table partitioning created in Enterprise Edition my be supported in Standard Edition, just that...

GSquared (8/10/2009)

---

Lynn Pettis (8/8/2009)

---

sjsubscribe (8/7/2009)

---

GSquared, you still don't make sense. There is no place in our society for religious tests, no matter how well its masked. As the author asked...

Okay, I'm close. I think the difference I see in my nummay be due to rounding because of the small size of the decimal fields. The following code...

Gabriel P (8/9/2009)

---

Hello, I'm looking for a way to carry a continuous value across rows to calculate a weighted average.

create table t1

(

record_id int identity(1,1),

...