try this....based on your sample data (I think)

WITH rt_cte as (

SELECT a.[WK NO],

AC= MAX(AC),

comp= MAX(COMP),

AUSD= SUM(CASE WHEN SOA_TYPE = 'Agent' THEN USD_AMOUNT ELSE 0 END),

FUSD= SUM(CASE WHEN SOA_TYPE...

try this.....

with cte as (

SELECT ID

, COUNT(*) AS cnt

, MIN(orderdate) mind

, MAX(orderdate) AS maxd

FROM #TEMP

GROUP BY ID)

SELECT cte.ID

, t2.Orderamt AS CurrentAmt

, t1.Orderamt AS PreviousAmt

FROM cte

INNER JOIN #TEMP AS t1

ON cte.ID...

the following article may help you

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

based on Lynn's previous code...I think the performance can be improved ... comments in the code

test script:...about 20secs and hopefully provides a test sample that imitates your real world

IF...

Lynn Pettis (6/29/2014)

---

How about giving this a shot. You may also be able to run this against all ID_Resource entities at once instead of one at a time.

I'd try...

I think it would help us if you could explain the "rules" of your "application management planning...

J Livingston SQL (6/24/2014)

---

can you share the code you are running that takes 15 minutes?,,...having a better insight...

can you share the code you are running that takes 15 minutes?,,...having a better insight of what is...

a.guillaume (6/22/2014)

---

Hi,

ARNAUD should be approved absent from 12:00 p.m. to 1:00 p.m. (lunch?)

but actually absent from 11:45 a.m. to 1:15 p.m.....

so therefore he was AWOL(!) 11:45am to 12:00 pm and...

Jeff Moden (6/21/2014)

---

a.guillaume (6/19/2014)

---

ARNAUD is working the 06/19/2014

He can't work on

00-8:00

12:00 p.m. to 1:00 p.m.

10:00 p.m. to...

had a longer look at this...but cant resolve...

can we assume that if [Resource_ABSENCE].[Id_Raison_absence] = 1 then the user is absent all day and therefore .... Théo minus absence = 0

a.guillaume (6/19/2014)

---

Day NbMinTheo Théo minus absence

2013-12-09 450 ...

thanks for the script...can you please confirm what results you are expecting from this data...just take a single day as an example

thanks

can you please supply table create / sample data insert scripts and the expected results for the sample data.

pls try and cover all eventualities .....eg do some people work overnight...