Viewing 11 posts - 1 through 11 (of 11 total)
4) Then it will take Future3 date column and add 2 weeks which exclude weekends & holidays to update future4 Date and all the columns updated in ...
January 8, 2016 at 2:54 pm
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 Date ...
January 8, 2016 at 12:37 pm
Microsoft have made it such a long winded process for BI developers to set up a local environment. I have recently bought a new laptop and it took me a...
January 6, 2016 at 10:05 pm
Ok, Az ... this is not the most streamlined, and it's not formatted pretty, but it works:
Also, I included a temp table named #workdb to get it to work of...
January 5, 2016 at 3:56 pm
Question, I assume the following is incorrect:
Holidays:
7-Jul-2016 to 13-Jul-2015
13-Sep-2016 to 16-Sep-2015
20-Sep-2016
and that what you really mean is:
Holidays:
7-Jul-2016 to 13-Jul-2016
13-Sep-2016 to 16-Sep-2016
20-Sep-2016
I'll wait to hear your answer before doing any more...
January 5, 2016 at 12:19 pm
:pinch:
Ok, let me get this straight.
Since I work in:
- Visual Studio
- SQL Server
AND
Since I have installed both:
-Visual Studio 2013 Professional
-SQL Server 2014 Enterprise Edition
I DO NOT actually have SQL Server...
January 5, 2016 at 11:26 am
Wait, what? where? how?
SSDT is part of SQL 2014?
Where, how, what did I miss?
January 5, 2016 at 10:15 am
Ok, I opened Visual Studio 2013
File > New > Templates ...
and yes, no "Business Intelligence" and hence no "Integration Services Project"
following that, per your suggestion I went out and downloaded:
SSDTSetup.exe
Before...
January 5, 2016 at 9:35 am
Ok, I have Visual Studio 2013 Installed, working and ready.
What do I need to do next?
January 5, 2016 at 8:58 am
Ok, I think what you are asking is you only want the number of weekdays between dates, correct?
DECLARE @Start DATETIME
DECLARE @Stop DATETIME
DECLARE @NDAYS INT ...
January 5, 2016 at 8:56 am
Ok, so ... so far:
EXAM 70-462
- Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
EXAM 70-463
- Training Kit (Exam 70-463) Implementing a Data Warehouse...
December 28, 2015 at 10:10 pm
Viewing 11 posts - 1 through 11 (of 11 total)