Official Pythian Blog - SQLServerCentral

Blogs

This is an interesting invitation this month. Jeff Ianucci is a new host, and...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

The first version of my accounting assistant could not find a single purchase of...

Comments posted to this topic are about the item Pay for Performance, which is...

Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa Tengah 56200

Jl. Pangeran Diponegoro No.120, RT.002/RW.010, Serdo Barat, Kutoarjo, Kec. Kutoarjo, Kabupaten Purworejo, Jawa Tengah...

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;