T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21,...
2011-08-10
1,099 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
The Best Part of My New Job
The Best Part of My New Job
Come to the Dark Side, We have Nutter Butters
If you had told me a...
2011-08-04
917 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,142 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,101 reads
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter
It’s time for July’s Meme Monday post, and...
2011-07-11
2,515 reads
Misleading Error 1475 While Setting Up Database Mirroring
Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->
I was doing some practice work yesterday testing out some mirroring...
2011-07-11
1,167 reads
June Meeting - Data Architecture VC
June Meeting - Data Architecture VC
Data Architecture VC presents Karen López:
Subject:You've Just Inherited a Data Model: Now What?Start Time:Thursday, June 16,...
2011-06-10
702 reads
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...
2011-05-25
1,526 reads
Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-21
1,071 reads
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-19
2,819 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
Alamat BCA KCP Pasar Kenari Telp:08218200203
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Alamat BCA KCP Biak Telp:08217555651
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Plaza Index Telp:08217555651
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
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