Viewing 11 posts - 1 through 11 (of 11 total)
Thom A (12/7/2016)
December 7, 2016 at 7:38 am
Not possible, there's a whole change request which takes ages and a lot of the requests we stick in are rejected because it's not 'business critical'. The company that runs...
December 7, 2016 at 5:44 am
Thom A (12/7/2016)
This would be an extremely easy task with a Calendar Table[/url].This should get you started:
Thanks, but with our remote access to MS Server, we can't create Views so...
December 7, 2016 at 5:26 am
DamianC (12/7/2016)
As you want part days, I can't think of a quick answerTake a look at this http://stackoverflow.com/questions/5274208/calculate-business-hours-between-two-dates
Thanks, I already looked at this post but it only serves weekdays and...
December 7, 2016 at 4:55 am
Adi Cohn-120898 (12/7/2016)
December 7, 2016 at 4:52 am
From my create table in the OP, I have a temp table which holds the opening hours Mon-Fri 8am-22pm and Sat/Sun 8am-18pm.
I only want to calculate total hours within these...
December 7, 2016 at 4:13 am
Adi Cohn-120898 (12/7/2016)
you can use the function datediff to calculate the difference between 2 points of time.Adi
Yes but it won't include just opening hours
December 7, 2016 at 3:59 am
Eric M Russell (9/7/2016)
Tell your DBA that she get's the job done, but she's kind of clunky when it comes to offering constructive advice about T-SQL.
I should have asked for...
September 7, 2016 at 8:28 am
Thanks for your input Dixie
Did he say it looks clunky or it runs clunky?
He just said it looks clunky
Put the join ON clauses on the same line since they were...
September 7, 2016 at 6:52 am
Thanks for the info guys, I've been learning SQL for a while now and I want to get my scripts as effective as possible.
September 7, 2016 at 6:31 am
Viewing 11 posts - 1 through 11 (of 11 total)