Introduction
For one of our customers we needed to create customized reports that could not be easily implemented by using standard Power BI components. We explored different ways how to...
2023-09-22 (first published: 2023-08-28)
412 reads
Introduction
You know that feeling when you have your PowerShell script written, saved and now you need to execute it? But every time you want to use the script, you...
2023-09-11 (first published: 2023-08-22)
763 reads
The buzz around Microsoft Fabric has been growing steadily since its announcement. This game-changing platform unifies several critical Azure services, including Data Factory, Synapse, and Power BI, all under...
2023-09-07
90 reads
Introduction
In today’s data-driven landscape, skilled data engineers are the backbone of organizations, driving insights from vast data streams. If you’re aspiring to become a Data Engineer Associate and harness...
2023-09-04
78 reads
Introduction
Fabric Warehouse is a new interesting tool used for data management and analysis. While it offers a wide range of features and functionalities, it is essential to be aware...
2023-08-11 (first published: 2023-07-26)
522 reads
What will be much easier with Microsoft Fabric?
Microsoft Fabric is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new...
2023-07-24 (first published: 2023-07-11)
411 reads
Červencové novinky ze světa dat byly trochu prázdninové a odpočinkové, ale i tak jsme se podívali na pár zajímavých a šikovných demíček, které by se vám mohli hodit.
Co nového...
2023-07-19
58 reads
2023-07-19
20 reads
Recently I was doing a cleanup of one model, and I used Best Practice Analyzer (BPA) in Tabular Editor as a helper. Later, I realized I forgot to set...
2023-06-05 (first published: 2023-05-22)
562 reads
Recently we faced the issue on one project to refresh power BI desktop file to update structures.
There could be various reasons why you would like to automate PB desktop...
2023-05-22 (first published: 2023-05-09)
524 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
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