Las Vegas April 2013 UG Meeting
AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...
2013-04-10
866 reads
T-SQL Tuesday #41 - Presenting Opens Doors
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
965 reads
SQL Server – Generate Calendar using TSQL
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-16 (first published: 2013-04-09)
13,257 reads
T-SQL Tuesday #41 Becoming a SQL Server “Presenter” GET INVOLVED!
Hello Dear Reader! It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...
2013-04-19 (first published: 2013-04-09)
1,359 reads
T-SQL Tuesday – Love For Presenting – #TSQL2sDay
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number...
2013-04-09
571 reads
T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,158 reads
TSQL Tuesday #41–Presenting and Loving it?
Well sort of…it took a while.
I’d done some plays and singing at school but my mother made me practice...
2013-04-09
869 reads
T-SQL Tuesday #41 – Presenting and Loving it!
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
600 reads
Carry On
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
625 reads
T-SQL #41 - Presenting and Loving It!
As I was
exploring the twitter verse, I came across a post with the invitation to this
week’s TSQL
Tuesday #41, and immediately...
2013-04-09
2,315 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