Thanks so much! For some reason the default showed as black in the options even though it was teal which is why I missed it. I explicitly set...

I'm not sure how your SSIS package is set up, but you can get that with a query using CROSS JOIN:

SELECT *

FROM (

SELECT DISTINCT Date

...

Sure, here it is:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

May 3 2005 23:18:38

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service...

Hi All,

The WITH RECOMPILE didn't seem to help, but I moved my parameters into local variables and (Woohoo!) it's running fast!

Thanks for all of your help! I really appreciate...

Here is the procedure:

CREATE PROCEDURE usp_NetCollectedByCollector (

@Merchant_ID char(5) = NULL,

@BegDate datetime = NULL,

@EndDate datetime = NULL,

@User_IsCollectionsRep bit = NULL

)

AS

DECLARE @CurrDate datetime

SET @CurrDate = Convert(varchar(32),getdate(),101) + ' 00:00:00'

IF @EndDate IS NULL

IF...