Run Stored Procedure In Stages/Batches

Hi guys I have a large student image database which contains four tables:

I run this Stored-procedure to get counts of the images in the database based on ImageType and Image Area, the SP writes the values to my ImgCountsTypeAreaLocCity table

to run the SP i do i enter the ImageType and ImgArea e.g: exec GetImage 'group shot','Campus 3'

create procedure [GetImage](@type varchar(50),@place varchar(50)) as
begin
      insert ImgCountsTypeAreaLocCity(ImgTYpe2,ImgAreaLocCity,ImgCount)
      SELECT @type,@place,COUNT(*) AS ImgCount
      FROM ImageLibrary
      WHERE
      (ImgType2 = @type) AND (Area = @place or Location = '' or city = @place) AND Status = 'L'
end

I would like to be able to run the Stored-procedure in batches based on the dbo.ImageType ImgTypes , so if I want to Process image type 1 through to 100 today it will
loop through all the rows in the dbo.ImgArea table using the ImgTypes 1 to 100 until its finished, then the next day I can process dbo.ImageType ImgTypes 101-500

 how do i go about doing this? To run the stored-procedure I would just type exec GetImage 1, 100 then the next day it could be exec GetImage 101, 500



and so on how do i go about doing this?

here is a sample of the data in my tables
dbo.ImageLibrary
photoID      sName            Camera            status      ImgType1      ImgType2      Area            Location      City            Misc1
1      Student Group a      Sony SLR      L               NA      group shot      Campus 3      Campus 3      BOS            NULL
2      Student Group b Cannon Digi      L               NA      single            Building 5 nine      Boston            Building 5 nine      NULL
3      Student a      Sony SLR      D               NA       group shot      Campus 3      BOS            Campus 3      NULL
4      Student Group b      NIKON            L               NA      single            Building 5 nine      Building 5 nine Building 5 nine      NULL
5      Student Group d      Cannon Digi      L               NA      Group Animated      New York City      New York City      New York City      NULL
6      Student b      NIKON            L               NA      group shot      Campus 3      Campus 3      New York City      NULL
7      Student a      Cannon Digi       L               NA      groups 3 to 4      New York City      New York City      New York City      NULL
8      Student Group c      Cannon Digi      L               NA       group shot      Campus 3      Campus 3      BOS            NULL
9      Student a      NIKON            L               NA      Group Animated      Campus 3      Campus 3      BOS            NULL

dbo.ImageType
TypeID      ImgType
1      range group close
2      Angle Shot Close Up
3      group shot
4      single
5      Group Animated
6      double sports play
7      groups 3 to 4

dbo.ImgArea
AreaID ImgArea
1      Campus 3
2      New York City
3      Campus 2
4      Building 5 nine
5      Area 2 stairs
6      campus 1
7      florida beach lawn
8      outside lawn

dbo.ImgCountsTypeAreaLocCity
ID ImgTYpe2     ImgAreaLocCity  ImgCount
1 outside lawn  campus 3         25
2 outside lawn  campus 2         5
3 outside lawn  campus 9         0