PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject: On beyond Zebra AdventureWorks or where did I go wrong?
Level: 200 (Intermediate)
Start Time: Thursday, November 17, 2011 8:00...
2011-11-15
535 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,067 reads
Un-SQL Friday: Stop SOPA!
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,063 reads
The Calendar Driven Organization
I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...
2011-11-15
747 reads
Going to PASS 2012!
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
389 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what I wrote here and here. Since writing those last...
2011-11-15
12 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what...
2011-11-15
852 reads
DBA in Space: Behind the Scenes Part 2
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
563 reads
ColoradoSQL in November (2011)
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-11-15
829 reads
Quotename in SQL
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...
2011-11-15
8,093 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