2021-03-18
680 reads
Bob Hovious
- Interests: Eclectic.
Bones of SQL - Practical Calendar Queries
After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.
2020-05-15 (first published: 2016-10-13)
8,200 reads
The Bones of SQL - The Holiday Table
This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.
2018-12-25 (first published: 2016-09-19)
8,119 reads
Bones of SQL – Grouping By User-Defined Calendar Periods
Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.
2017-12-08 (first published: 2016-09-26)
4,189 reads
Bones of SQL - The Calendar Table
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
2017-11-24 (first published: 2016-09-08)
18,224 reads
2016-09-05
1,361 reads
2016-08-18
1,514 reads
T-SQL: Why “It Depends”
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
2010-03-16
13,245 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
Which Kanha National Park Tour Package Is Best for Families?
By Kanha Booking Wildlife Adventure India
Opting for the perfect Kanha National Park tour package is a necessity for a...
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers