PASS
I arrived home this morning after another PASS Summit. This is my 6th in a row. Each year I have...
2008-11-22
441 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
PASS, anyone?
In less than two days I'll be in Seattle for my 6th PASS Summit. I am trying to put all the...
2008-11-14
475 reads
Modifying Data - SQL School Video
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
2008-09-30
3,739 reads
Summarizing Data with Aggregate Queries - SQL School Video
Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
2008-08-28
4,978 reads
Speaker workshop
Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...
2008-08-19
1,329 reads
SSWUG SQL Server Virtual Conference III
There are many technical conferences available for SQL Server professionals, such as PASS. I have been lucky enough to go...
2008-08-10
1,044 reads
Patching
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,928 reads
SSWUG Virtual Conference II
Today is day one of the SSWUG SQL Server Virtual Conference II. This has been really fun so far. Our...
2008-06-24
1,525 reads
Virtual Conference II
Check out the SSWUG Virtual Conference next week. Here is a link with more information: http://www.vconferenceonline.com/sswug/demo.asp . The first 200 people...
2008-06-19
1,589 reads
RC0 and HierarchyID
I gave a presentation Tuesday to my local SQL user group on 2008 T-SQL and data types. One of the items...
2008-06-13
774 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 Batu Ceper Telp:08218200203
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Kartini Telp:08218200233
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Alamat Bank BCA Wisma 46 Telp:08217555651
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
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