Definitley sounds like the column is using a float rather than a decimal. Floats are imprecise and so holding decimal numbers will lead to rounding errors.

This is especially true when...

"no context switching and no disk queuing, no CPU queuing"

That would be a nice world

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The best way I know is to use sqldmo. this will tell you if the server has sql server, whether it is started, starting, stopping or paused.

Simon Sabin

Co-author of...

How have you created your tables and union. You need check constraints on the tables to partition the data. i.e on has districts 1 to 10 and on has all...

you can create a view of your table with only the relevant columns and bcp into that rather than the table

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

you will have to rename the table. Drop constraints.

Create your new table with the correct datatype and then populate the data back in form the renamed table, Using a convert...

It seems to point to having just installed the client tools and not the server components. SQL server can run on any system 98 onwards (enterprise version has to run...

any select statement that does not return the results into a variable or table will be returned as a rowset to the calling code. With ado these can be cycled...

I think the problem could be todo with the position of the tabA.status = 'Active' clause.

If you only want result from tableA that are active move it to the where...

Try

Insert into tblRCStudentGrades(RCpermnum)

select Permnum as SDpermnum

from Student_Data_Main

Where grade = '00'

or grade = '01'

or grade = '02'

or grade = '03'

or grade = '04'

or grade =...

I get it as well and doesn't seem to cause a problem

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Only used Oracle at version 8 and you definitely had to be careful becaue you could only grow a file a fixed number of times, and thought a similiar thing...

Tom has it.

If you are using named pipes the user account makuing the connection has to have permission to start a session on the sql server, if the user is...

You can't use functions in the EXEC statement. I assume char(39) is a ' in which case use 2 of them i.e

EXEC stpMySproc ' WHERE CompanyName LIKE ''haas%'''

Simon Sabin

Co-author of...

Datf comment but does the dll reference anything that is not registered on the sever?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088