Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
565 reads
function
2017-05-09 (first published: 2017-05-03)
2,908 reads
Split and concatenate function
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
3,137 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,823 reads
Get daylight savings time
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
2,031 reads
2010-01-11
10,552 reads
return a file Last Modified Date
This function takes a UNC file as a parameter and return the last modified date
2010-01-13 (first published: 2009-12-17)
2,583 reads
4-4-5 Calendar Functions, Part 1
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
2010-09-06 (first published: 2009-09-28)
24,443 reads
Splitting the string with unique delimiter.
The statement is splited into columns according the delimter and it has been captured in the table datatype.
2009-06-29 (first published: 2009-06-22)
1,220 reads
Two scripts to spell out numbers in words
These SQL functions will allow you to convert decimal numbers to words
2009-02-02 (first published: 2009-01-22)
2,034 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers