so...

Firewolf (8/29/2016)

---

J Livingston SQL (8/29/2016)

---

Firewolf (8/29/2016)

---

I just did now - it works on the sample data, but it hadn't for...

Firewolf (8/29/2016)

---

I just did now - it works on the sample data, but it hadn't for the true data. ...

Firewolf (8/29/2016)

---

I verified that this table matches the results from the SQL table code...

please can you reconfirm the results you are expecting from the latest sample data

theres some thoughts here

https://coding.abel.nu/2013/01/avoid-broken-views-in-sql-server-with-schemabinding/

mw112009 (8/25/2016)

---

if object_id('tempdb..#t') is not null DROP TABLE #t;

create table #t( str varchar(4000) );

insert into #t(str) values ( 'fox' );

insert into #t(str) values ( 'fox fox fox' );

insert into #t(str)...

please provide table script and sample data that describes your problem.

thanks

this article by Jeff Moden may give you some ideas

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

I asked a similar question on one of your earlier posts.....

for example

"ProgramFirstday" = 1

"ContractDetailFirstDay" = 7

how do you determine whether this is 6 day delay OR 1 day early?

just a thought...but looking at this post and a previous post of yours........ we might be missing a few tricks to get you to your results, maybe...maybe not.

Are you able...

TheSQLGuru (8/24/2016)

---

Given that this is a free forum, I don't know that you will find anyone that will take the time to set up imports from a 5+MB excel spreadsheet...

can I please get some clarification.....for example

in #updateprogramtables......"ProgramFirstDay" = Monday and "Programstarttime" = 05:00:00

and

in #updatecontractdetailtable .... "ContractdetailFirstDay" = Sunday and "Contractdetailstarttime" = 23:00:00

what results are you expecting?

eg...is this...

perhaps...

plenty of ideas and thoughts to be found here

https://www.simple-talk.com/sql/t-sql-programming/calculating-values-within-a-rolling-window-in-transact-sql/