Viewing 15 posts - 31 through 45 (of 49 total)
Hey, guys, I worked on the database problem over the weekend, but am not very satisfied with the results.
My database...
November 28, 2005 at 10:58 am
Thanks for your ideas. The client's shop is closed Thursday - Sunday for Thanksgiving so I will have lots of time to work on it. I am 2500 miles away...
November 23, 2005 at 10:05 am
Actually, after the recompile, it still messed up. I ran it 6 times. It performed the INSERT 4 times and displayed the recordset 2 times. So I retyped the whole...
November 7, 2005 at 10:04 am
I noticed in your original post the following:
CREATE TABLE #BookCategory (
Category CHAR(2),
It could be the CHAR(2) giving you the problem. The Category is getting a blank space padded to the...
November 4, 2005 at 10:39 am
Just got back to this client today and got your responses. Thanks to everyone for the ideas.
Recompile did the trick.
Thanks again.
November 3, 2005 at 11:03 am
No you do not need VS2003 to use ASP. It is helpful to have it for developing ASP.NET but it is still not "required".
October 20, 2005 at 2:10 pm
It will trim just fine as long as the developer does it in a program (not in SQL).
September 1, 2005 at 5:59 pm
Almost everyone in Alaska drives a truck. Mine is a 2004 Chevy Avalanche.
July 19, 2005 at 6:43 pm
HTH means "Hope this helps". Here's a great site for deciphering acronyms:
July 8, 2005 at 6:19 pm
Just add the keyword DISTINCT after the word SELECT and you'll get rid of the multiple rows.
July 7, 2005 at 6:35 pm
I use the following vbscript that is scheduled to run nightly and it fills SQL tables with data from ADSI. Then our webpage can display it out of the SQL...
May 20, 2005 at 4:58 pm
Worked perfectly. Thanks a million. You're my hero.
May 20, 2005 at 10:23 am
"legacy" refers to old computer systems, usually big, honking mainframes, and the data that is still stored on them
April 21, 2005 at 6:40 pm
If you google the following with the double-quotes, there's a ton of info:
"max pool size was reached"
March 10, 2005 at 5:01 pm
Viewing 15 posts - 31 through 45 (of 49 total)