newbee sp_spaceused problem 
Author Message
 newbee sp_spaceused problem
I have a script that fetches all user tables and exec as sp_spaceused on them. I
need to convert the results to int and use this data for calculations. The
problem being is that sp_spaceused puts kb on the end of the results. I would
just use the right operator but the position of the chars is diffrent in all the
rows.

Any help would be much appreciated.  



Tue, 08 Jul 2003 02:26:31 GMT
 newbee sp_spaceused problem






-Lars


I have a script that fetches all user tables and exec as sp_spaceused on
them. I
need to convert the results to int and use this data for calculations. The
problem being is that sp_spaceused puts kb on the end of the results. I
would
just use the right operator but the position of the chars is diffrent in all
the
rows.

Any help would be much appreciated.



Tue, 08 Jul 2003 06:50:12 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Newbee: Trigger problem

2. Newbee: Problem when installing SMS 1.2 on SQL 7

3. Newbee problem

4. NewBee's Network Connection Problem using VB

5. Newbee Question: Problem with mSQL driver

6. sp_spaceused problems

7. problems with sp_spaceused on Powerbuilder

8. Problem with SQLServer's sp_spaceused stored procedure

9. Problem with SQLServer's sp_spaceused stored procedure

10. sp_spaceused for DB Vs. sp_spaceused <table_name> disparity

11. newbee seeks upgrade help

12. sql 7 newbee


 
Powered by phpBB® Forum Software