DTS vs Linked Server
We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it...
2007-09-25
1,607 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Writing in my sleep
When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming...
2007-09-25
1,290 reads
PASS Report
Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to...
2007-09-23
1,345 reads
PASS Report Part 2
This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many...
2007-09-23
1,375 reads
Removing the Builtin Administrators - Some Pitfalls to Avoid
The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.
2007-08-10 (first published: 2005-01-12)
30,161 reads
CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
454 reads
Stored procs vs user defined functions
I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great...
2007-05-19
1,319 reads
Aggregate Queries
They are a basic type of query that every DBA and developer should be able to write, but aggregates are sometimes misunderstood and result in strange behaviors and results. Kathi Kellenberger brings us a tutorial on what aggregate queries are and a few hints on how to become more proficient at writing them.
2007-03-16 (first published: 2005-12-19)
37,539 reads
Conditional formatting in Reporting Services
Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a...
2007-03-11
1,337 reads
Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,735 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