Viewing 10 posts - 241 through 250 (of 250 total)
Thanks, I will try this. CSDunn
quote:
Two choices as I see it. First is to wrap all of your query, except the OScore...
March 17, 2003 at 9:57 am
It turns out that I had a mismatch in the constraint I was testing vs. the one I was altering. I'm having to develop this application and answer calls on...
March 5, 2003 at 1:07 pm
The other option I was considering was just to create a calculated field in the MS Access Project (ADP) report that uses this particular query by implementing 'IIF' statements in...
February 27, 2003 at 9:57 am
I tried 'AVG(CAST(TS.TestScore AS Decimal(4,2))) AS Average_Score' and was still getting the 'Arithmetic Overflow' error, so I tried a couple of tests:
1. I made a copy of the table from...
February 20, 2003 at 11:19 am
Well, the log clearly says that the eval period has expired. I didn't expect the cause of the problem to be so easy to find. Thanks. cd.
January 27, 2003 at 3:57 pm
The inability to make a connection to that instance of SQL Server is preventing me from looking in the 'Management' section of that instance.
January 27, 2003 at 2:38 pm
I wound up putting my error checking code in the application interface. In this case it was an Access 2000 Project.
I found out that SQL Server 2000 passes its errors...
January 6, 2003 at 4:59 pm
Actually, I had a unique index and a unique constraint set up on the same fields. I dropped the constraint, then added a new unique nonclustered index with Ignore_Dup_Key, and...
January 2, 2003 at 5:29 pm
quote:
I agree. I usually trap such errors in my app before calling upd or if using a stored proc then I trap...
December 12, 2002 at 10:54 am
Viewing 10 posts - 241 through 250 (of 250 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy