I can't get the information for Panasonic from the data in your Product and ProductDetail tables, they don't exist. Also, Mark's code is very close to what you are...

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially for newbees. Better...

Bear with me, have you checked to see wha the system table says:

select * from sys.server_principals

I can't recreate your problem, so I am having to guess here.

How are the users connecting to the database? is this an application using ODBC/OLEDB, SSMS, something else?

Is it possible that there needs to be a change on the user...

steve_melchert (8/10/2009)

---

> It really is up to the authors to seek out peer reviews of their

> articles before publication. The editor chooses to publish submitted

> articles with...

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