Database

<br />
(<br />
	@DateFrom datetime =null,<br />
	@DateTo datetime =null<br />
)<br />
as<br />
	begin	<br />
		<br />
		select <br />
			PageName,<br />
			count(PageName) as [Page Name]<br />
		from<br />
			PageViews<br />
		where <br />
			DateEntered > <br />
				case when @DateFrom is null then (select convert(char(12),min(DateEntered)) from pageviews)<br />
					<br />
				else<br />
					dateadd(day,-1,@DateFrom) <br />
				end				<br />
		and <br />
				DateEntered <<br />
				case when @DateTo is null then (select convert(char(12),max(DateEntered)) from pageviews)<br />
				else<br />
					dateadd(day,1,@DateTo)<br />
				end<br />
		group by<br />
			PageName<br />
		order by <br />
			[Page Name]<br />
<br />
	end<br />
<br />

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