Lovely solution !

Hi,

Your algorithm is faster than mine but it does not fully meet my expectations

We need to calculate the hours scheduled and that is really the hours worked by each...

Hi,

Thank you for all your answers and proposed solutions

I applied that Lynn

With my method it takes 15 minutes and 12 minutes with the Lynn solution

I think I'll have to...

hi

"No problem" for night shifts over two days

-> we record the hours per day

-> if someone works beyond a day, we split into 2 ranges presences (or absences)

we...

hi,

every day, the statistics are calculated

  - Tables of statistics are truncated

  - We calculated for the entire base hours of attendance, hours of absences, financial allocations are made...

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 also...

hi,

the resource was not present for this '09/12/2013'

0 to 495

720 to 780

1005 to 1440

so, he has 1440- (495+60+435) = 450

He's absent during the time 510 to 555

so...

Day NbMinTheo Théo minus absence

2013-10-01 450 ...

this script contains one example

Regards

Arno

"the only problem with this test is that the three queries will return different results if you revise the source and target tables to cover the full range of scenarios....

I'm ok with Darren

To understand, I tried this 3 SQL in a lot and obtain this results

set statistics io on

----- SQL1 ------

SELECT .[ID],.[Item], .[Price], .[OrderDate], .[Units], .[ShipmentDate]

FROM [Source] ...

Sorry, see post later

hello,

The join between #source and #Target in the SELECT .... EXCEPT is not essential

You can obtain the same result with a best cost

SELECT .[ID]

,...

CREATE TABLE TEST(

Code_test int IDENTITY(1,1) NOT NULL,

shortname varchar(14) NULL,

Name varchar(38) NOT NULL,

CONSTRAINT [PK_TEST] PRIMARY KEY (Code_test)

)

go

--Create a view without the identity column

create view vtest

as

select shortname,...

Hi,

I used the instruction containstable (myTable, MyColumn, 'C++' )

it's work fine with 'C++', 'C#' ...

You can see this

http://technet.microsoft.com/en-us/library/ms189760.aspx

Best regards