Free SQL Server in the City Event to be Held in LA
Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles,...
2011-09-30
1,422 reads
SQL Server MVP Deep Dives: Volume II
Two years ago when SQL Server MVP Deep Dives: Volume 1 was released, I had the opportunity to contribute two...
2011-09-30
1,777 reads
Presentation Files: 10 Things All BI Administrators Should Know
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
I was very excited to get to present...
2011-09-30
2,011 reads
SSIS Variable and Expressions Followup
Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL...
2011-09-30
4,266 reads
SQL Bits Training Day
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing...
2011-09-29
1,596 reads
PASS Summit 2011: My Itinerary
Here goes with what I hope to achieve the following week in Seattle, WA Oct 9-15 for my 4th summit.
I...
2011-09-29
1,423 reads
Slides & Samples for my SolidQ Summit Sessions
As I have announced in all of my sessions last week in Budapest at the SolidQ summit,
you can find here...
2011-09-29
1,484 reads
Slides & Samples for my SQLdays Sessions
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays
conference can find here the
Slides...
2011-09-29
1,417 reads
SSIS For Each Column in a Data flow
Previously I wrote a blog on how to do a for each loop to look through each col in an...
2011-09-29
1,261 reads
Getting Previous Row in SSIS Data Flow
There is no native function built in to SSIS to get the previous row in the data flow. But with...
2011-09-29
1,776 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