Database

USE PD9

DECLARE @RC int
DECLARE @datebegin varchar(10)
DECLARE @dateend varchar(10)

SET @datebegin = '01/01/2007'
SET @dateend = '01/15/2007'

--this is a dataset of our sales reps
DECLARE sales_cursor CURSOR
FOR
   	SELECT DISTINCT
		[ABAN8]
	FROM 
		[vF0101_RepDetails]
	ORDER BY [ABAN8]

OPEN sales_cursor

DECLARE @an8 int

FETCH NEXT FROM sales_cursor INTO @an8

WHILE (@@FETCH_STATUS <> -1)
BEGIN
   IF (@@FETCH_STATUS <> -2)
   BEGIN  
	-- i'm looping through a dataset of our sales reps
        -- now i need to get a dataset from the below sproc
        -- loop through that dataset and put it in a temp table
        -- the problem is getting the dataset from the next line - HOW??
	-- EXEC @RC = [PD9].[dbo].[usp_rs_getSalesShipments] @an8, @datebegin, @dateend
	-- print @RC
   END
   FETCH NEXT FROM sales_cursor INTO @an8
END
CLOSE sales_cursor
DEALLOCATE sales_cursor