Count the Number of Weekend Days between Two Dates
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
2020-10-16 (first published: 2018-08-23)
12,846 reads
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
2020-10-16 (first published: 2018-08-23)
12,846 reads
On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.
2020-04-03 (first published: 2018-08-16)
6,987 reads
2018-08-14
1,121 reads
Sometimes you need to output blank lines
- in effect displaying Records for Missing Data. This article explains how to use a CTE to do this
2018-08-09
4,876 reads
Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL
2018-08-02
3,397 reads
2018-07-31
1,147 reads
DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this
2018-07-26
1,849 reads
2018-07-23
1,131 reads
T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.
2018-07-16
4,197 reads
This short article shows a simple example of how to generate completely random sample output from a Dataset
2018-07-12
6,969 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers