I apologize for not responding back. I've been on vacation. There are some great comments so it will take me some time to look through them all.

There are two scenarios:

Slow to run.

date_effective <= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1)

Fast to run.

date_effective <= cast(cast(month(getdate()) as varchar(2)) + '/' + '01' + '/' + cast(year(getdate()) as varchar(4)) as...

date_effective is set up as a datetime.

Just for clarification, hard coding the date or using a parameter seems to be very efficient. It's when I use the...

Phil's suggestions is simplest. And when dealing with Excel I have found the simpler the better. The only step I would add would be to delete any files...

Query used:

select

m.first_name, m.last_name, gh.*, pro.*

from enterprise.dbo.members m

inner join enterprise.dbo.group_header gh

on gh.group_num = m.group_num

left join dim_programs pro

on pro.program_code = m.program_code

where

m.group_num in ('SFVA00', 'SFA000', 'SFPA00', 'SFN000')

and date_effective = '1/1/2006' or...

Unfortunately, my NDA doesn't allow me to publish the table DDL;(

Execution plans attached.

I have a very dumb question, but how do you post an execution plan?

I'll get it posted tomorrow. Can't seem to VPN in to get now.

Sorry for not posting it earlier as I didn't think the query mattered as the...

Does anyone know what a 'Worktable' is? This appears in the first io block I posted earlier. The second one (the longer running one) does not have any...

I thought I'd include the statistics IO for both runs. Any assistance in interpreting this would be greatly appreciated.

Fast execution

(9028 row(s) affected)

Table 'CODE_DETAIL'. Scan count 4, logical reads 15,...

GSquared (7/14/2009)

---

Have you considered doing the date math in a statement before the query? That usually helps that kind of thing tremendously. (Assign the value to a variable...

Tried the code below

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1)

Took 19 seconds to run. Almost seems like it doesn't like DATEADD.

ngkahing (5/13/2009)

---

Hello JD,

I wonder if u can provide a little details of how we can add condition to the flow so that when I find a file, it executes the...

I can't speak for how to translate an Active X script to .net. But I ran into this issue when I was first moving out of DTS to SSIS...