Viewing 15 posts - 19,306 through 19,320 (of 26,490 total)
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...
August 10, 2009 at 1:29 pm
LP (8/10/2009)
jonwolds (8/10/2009)
Some points in this article no longer apply, some are mis-leading and some are just incorrect. Please read with caution.
Absolutely agreed. Very dangerous article espesially for newbees. Better...
August 10, 2009 at 1:07 pm
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.
August 10, 2009 at 1:02 pm
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...
August 10, 2009 at 12:51 pm
steve_melchert (8/10/2009)
> articles before publication. The editor chooses to publish submitted
> articles with...
August 10, 2009 at 12:43 pm
Also, could still use an explaination of what the function is attempting to accomplish.
August 10, 2009 at 12:31 pm
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...
August 10, 2009 at 12:30 pm
Without the DDL (including the collation for character fields) a little hard to determine where the problem is with the code.
August 10, 2009 at 12:29 pm
What is portnumber? This column isn't defined in the table variable and isn't used in a subsequent query of the table variable.
August 10, 2009 at 12:17 pm
GSquared (8/10/2009)
John Rowan (8/10/2009)
August 10, 2009 at 12:04 pm
In addition, could you explain what this function is attempting to do?
August 10, 2009 at 12:03 pm
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...
August 10, 2009 at 11:50 am
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...
August 10, 2009 at 10:52 am
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.
August 10, 2009 at 10:48 am
Tim Walker (8/10/2009)
Lynn Pettis (8/10/2009)
oli (8/10/2009)
Paul White (8/10/2009)
Gail's first post expresses it best, and in milder language terms than I might have used. ...
August 10, 2009 at 10:45 am
Viewing 15 posts - 19,306 through 19,320 (of 26,490 total)