I am just going to say that it doesn't seem like you are really trying that hard to figure out your solutions.  Having said that, here is a solution that...

Won't help if the WHERE clause just happens to include the entire table.  Seen it, had to help recover 10 years of data as a result of an incorrect date...

So will I.  I want a fifth title!

Try the following as your WHERE clause:

WHERE
tdate >= dateadd(hour,17,dateadd(week,datediff(week,0,getdate()),0)) and tdate < dateadd(hour,17,dateadd(week,datediff(week,0,getdate()) + 1,0))
and cast(dateadd(hour,7,tdate) as time) >= cast('00:00' as time) and cast(dateadd(hour,7,tdate) as time) <...

So, every Monday you start at that Monday at 17:00. This means that you get nothing when run during the first shift on Monday.  Is this correct or do you...

>> I remember learning Algol during a teacher strike while I was in High School back when dinosaurs still roamed the land. I actually liked the language. <<

I learned...

Of course I still lead where it matters, First Place Trophies!

??????????

Could be that I need more sleep (doubt that as I slept almost 12 hours last night) so I am still confused.  You really aren't providing the information needed to...

• This reply was modified 4 years, 8 months ago by Lynn Pettis.

So, you are pulling data for an entire week, and just want the data for the second shift (17:00 to 05:00).  Is this query only run once a week and...

A little bit of history here. The ANSI/ISO Standards committee decided that the grammar for SQL would be LALR(1). One of the committee members had access to a...

Looks like I will be losing to Ray tomorrow.  Two of my wide receivers didn't show up today.

For anyone trying to get to the original article, here is the link: https://www.sqlservercentral.com/articles/lookup-table-madness

Playoffs are in full swing, my bid to meet Ray in the Consolation bracket finals failed miserably.

The Ravens and Bulldogs square off, with the always interesting matchup of a...

You mean something like this?

 create table #gen
 (
 zplid int,
 CodetypId int,
 ZfeatureKey nvarchar(20)
 )
 insert into #gen(zplid,CodetypId,ZfeatureKey)
 values
 (9714,849774,1501290046),
 (9714,849774,1501099991),
 (9714,849774,1501555555),
 (9823,9732410,1501290046),
 (9823,9732410,1501099991),
 (9823,9732410,NULL),
 (5890,838651,1501290046),
...

I...