Building calendar table using MTVF
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,411 reads
Darko Martinovic
Calculate two internships
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2019-10-04 (first published: 2016-10-03)
502 reads
2019-10-04 (first published: 2016-10-03)
871 reads
Getting resource content from blocked process report
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2019-10-04 (first published: 2017-02-21)
1,266 reads
Getting resource name from blocked process report
The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2019-10-04 (first published: 2017-02-20)
2,021 reads
Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
2018-03-05
7,594 reads
2017-07-07
1,105 reads
Practical usage of SQLCLR: Building QueryToHtml function
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
4,116 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
14,722 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers