Viewing 10 posts - 1 through 10 (of 10 total)
December 3, 2018 at 9:17 pm
Phil Parkin - Monday, December 3, 2018 11:45 AMI cannot see a question here. What are you trying to achieve?
Is is...
December 3, 2018 at 11:51 am
Hello Gentlemen
Your kind support in above
December 3, 2018 at 11:36 am
@sql2012
Dear
if i change days from from 7 to 2 "DATEADD(DAY, num + 2",
from 7 to 2 " WHERE workday = 2" query doesnt give results for...
January 8, 2016 at 10:48 am
Dear Scot same results
January 8, 2016 at 10:45 am
Thanks for your reply
After running your query i got below results
start_dateFuture1_Datefuture2_datefuture3_datefuture4_date
2016-01-012016-02-05 2016-02-05 2016-02-05 ...
January 6, 2016 at 11:01 am
thank you for your time on this please can you check the difference between manual calculation and your query results why its different can u explain thanks
Your Query:
Start...
January 6, 2016 at 10:54 am
thank you for your time on this please can you check the difference between manual calculation and your query results why its different can u explain thanks
Your Query:
Start...
January 6, 2016 at 10:54 am
Dear Scot
First thanks for your reply, i am getting following error message
Msg 8116, Level 16, State 1, Line 8
Argument data type date is invalid for argument 2 of dateadd function.
Second...
January 5, 2016 at 2:26 pm
Thanks for reply and correction , all dates in 2016 🙂
January 5, 2016 at 12:57 pm
Viewing 10 posts - 1 through 10 (of 10 total)