Calculating Data Volume

• amarjyotib

  Grasshopper

  Points: 23

  More actions

  October 11, 2004 at 2:48 am

  #161650

  Hi,

      I am a newbie to SQL Server.

      In our office, we are running some Data Entry works for a Land Record Computerisation(LRC) project. We have hired some operators who work on contract. We need to calculate the volume(in MB) of Data entered by an Operator and they will be paid on the basis of the volume of Data they entered. They enter data to different tables in a single Database and "User" accounts have been created to each of them individually.

      Please suggest a solution for which I will be grateful.

     We are using SQL Server2000 on Win2000 Advanced Server.

  Thanks in advance.

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  October 11, 2004 at 5:16 am

  #526116

  If you know the userid why not SELECT UserID, COUNT(*) FROM tableX GROUP BY UserID ??

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net