Here you go , Very easy to prove.

drop table #Source

go

Create Table #Source

(

SourceID integer identity ,

e_start smalldatetime,

e_end smalldatetime

)

go

insert into #Source(e_start,e_end)

select top(1000) '01jan2010','01jan2010 01:00'

from sys.columns a cross join...

Sachin Nandanwar (12/23/2010)

---

How about this ?

;with cte

as

(

select e_start,e_end from #Source

union all

select DATEADD(minute,1,e_start),e_end from cte

where DATEADD(minute,1,e_start)<=e_end

)

select e_start from cte order by e_start

I think with Denali and introduction of SEQUENCES the above...

Then i suspect something like this....

Create Table #Source

(

dateRaw datetime,

Agent varchar(20),

Exception varchar(20),

e_start datetime,

e_end datetime

)

go

Insert into #Source(dateRaw,Agent,Exception,e_start,e_end)

select '2010-01-06', 'John', 'Lunch',...

To restate your problem :

You need a list of 5 minute intervals betweeen '07:45:00' and '20:15:00' that are between the start and stop time on wfm_actualactivity.

Is that correct ?

If i understand you correct , something like this ?

with cteCallCount

as

(

select ServiceLine1,ServiceLine2,COUNT(*) as CallCount

from SDM_Calls_Last_Year

group by ServiceLine1,ServiceLine2

),

cteCallServLine1Count

as

(

Select ServiceLine1,ServiceLine2,CallCount,

SUM(callcount) over (PARTITion by...

What DATATYPE are your Est and Diff columns , the comma implies that it is not int or numeric.

pdanes2 (12/21/2010)

---

RBarryYoung (12/20/2010)

---

I'd suggest that you Profile it and see what's really going on.

However, my suspicions would be that your Access engine is not executing all of your Statements /...

Can you post the DDL for the table ?

Also when you say "it doesn't work ", how doesnt it work ? Does it Error, updates zero rows ?

Something like this ?

UPDATE c

SET scw_temp = 'Sales Logix Live'

from Logix_Opportunity as o

inner join wce_contact c on o.accountid = c.accountid

where Extensions like 'Sales Logix...

Most likely a parameter sniffing problem.

Search for "Parameter Sniffing" and you should find some good resources.

Did you see this article ?

http://www.sqlservercentral.com/articles/T-SQL/71571/

Google is your friend

http://sqlblogcasts.com/blogs/simons/archive/2009/03/10/A-significant-part-of-sql-server-process-memory-has-been-paged-out.aspx

KennethParker (12/16/2010)

---

So, in the end I'd have something like this?

Select * from

<YourSourceTable> Cross apply dbo.CalcField_1(param1,param2,param3,...)

Cross apply dbo.CalcField_2(param1,param2,param3,...)

...

Cross apply dbo.CalcField_20(param1,param2,param3,...)

It looks pretty messy and uninviting, I must admit:(

What about my...

Feel foolish too as i didnt read the rest of you...

Sounds dangerously like ...