SQL Count And Related Questions

Hi, I don't use SQL much but I need to know how to form the following query against a SQL table. I have a single table with two columns - CurrentPage and LastPage.

I need to write SQL to perform a number of iterations of a particular insert into another table, depending upon the count from CurrentPage to LastPage i've put the following Pseudocode together, but need help implementing this.

Declare counter
Set counter = currentpage
If counter > lastpage
Goto task exit loop
Else perform task - (insert string into table)
Increment counter and loop

I've been playing / reading up, but i'm getting nowhere fast -

DECLARE @Count int
DECLARE @Current string
DECLARE @Last string

SET @Current= dbSL.tblPaging_colCurrentPage
SET @Count= dbSL.tblPaging._colPagingCount
SET @Last= dbSL.tblPaging._colLastPage
WHILE @Count <= dbSL.tblPaging._colLastPage

BEGIN
PRINT 'Hello World'
SET @Count = @Count +1
END


Any help much appreciatted.

Thanks
nme