Viewing 15 posts - 6,841 through 6,855 (of 9,399 total)
Using a "divide and conquer" approach to the problem, you first want to generate a set of times you're going to use to query your dbo.Appointment table.
with cteStart(starting_time) as (
...
December 10, 2014 at 6:23 am
There have been some really good discussions on this very topic. See http://www.sqlservercentral.com/Forums/Topic1585850-391-1.aspx for several different approaches to the problem.
December 10, 2014 at 5:56 am
Jeff Moden (12/9/2014)
Yes it is... please see the following article.
That's the perfect article and is exactly where I'd point you.
December 10, 2014 at 5:53 am
djj (12/10/2014)
crookj (12/9/2014)
Ed Wagner (12/9/2014)
sing4you (12/9/2014)
Ed Wagner (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
SQLRNNR (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
Clyde
The Glide
Slide
Trombone
Brass
tacks
High
Anxiety
Brooks (Mel)
History
December 10, 2014 at 5:26 am
It was simple math, but also a simple exercise in clear thinking, something I would think that most people who work in databases would be good at. Thanks.
December 10, 2014 at 5:25 am
sing4you (12/9/2014)
Ed Wagner (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
SQLRNNR (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
Clyde
The Glide
Slide
Trombone
Brass
tacks
High
December 9, 2014 at 1:52 pm
Jeff doesn't hit people with RBAR, he actively campaigns against it. High-velocity pork chops, on the other hand, are fair game. 😀
December 9, 2014 at 1:52 pm
djj (12/9/2014)
Ed Wagner (12/9/2014)
SQLRNNR (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
Clyde
The Glide
Slide
Trombone
Brass
December 9, 2014 at 12:19 pm
SQLRNNR (12/9/2014)
djj (12/9/2014)
Ed Wagner (12/9/2014)
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
Clyde
The Glide
Slide
December 9, 2014 at 11:03 am
First of all, welcome to the forums!
Let's start by creating some consumable DDL and data.
create table test (
Number char(3),
ProductName char(1),
Week char(3),
TTR Numeric(18,...
December 9, 2014 at 8:07 am
djj (12/9/2014)
Ed Wagner (12/9/2014)
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
Clyde
Browning
December 9, 2014 at 7:56 am
Lowell (12/9/2014)
this is the max for any database, regardless of being a user...
December 9, 2014 at 7:27 am
I find people trying to get development tasks done on this year's budget, so there are a lot of email flying around with unreasonable deadlines. I'm thinking the last...
December 9, 2014 at 7:23 am
crookj (12/9/2014)
sing4you (12/9/2014)
djj (12/9/2014)
HolidayBillie
Don't (be a hero....)
Bonnie (Tyler)
December 9, 2014 at 7:12 am
Nice question. And it's good to see that 78% of the answers thus far have been correct.
December 9, 2014 at 5:37 am
Viewing 15 posts - 6,841 through 6,855 (of 9,399 total)