Holidays and Calendar Generation
Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.
2017-12-15 (first published: 2016-02-16)
8,679 reads
Calendar Table
Time Slots - An Essential Extension to Calendar Tables
After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.
2015-05-05
7,291 reads
RE: SQL server 2000 and Outlook security issues?
I don't think the mention of Notepad was "silly" at all. It sounded to me as if Outlook was forbidden simply because it is a client application, but there are others. You have clarified above as a client application with lots of dependencies, which changes things somewhat. Since you're not using DTS package, it probably doesn't […]
2004-09-15
bulk copy execution failed when using DTS Import/Export Wizard
Hi Guys,I am using DTS Import/Export Wizard to copy database from one machine to another. I created a new database on the destination. In 'Specify Table Copy or Query' window, I chose 'Copy obects and data between SQL Server databases'. Error message is 'bulk copy execution failed'. Copy Database Wizard doesn't work either. How to […]
2004-07-08
8 reads
RE: Convert Columnar Data to Row Data
quote: That's why I included a where clause so that if you specif y one studentID you will get 75 rows you could specify several students paging by studentID also. Thanks, this has been a big help! The following is what I have set up: ************************** DECLARE @Grade AS Smallint DECLARE @TestID AS Varchar(10) SET […]
2003-12-03
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers