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...

Forums

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

Hi I have this slow query that is pulling data from a linked server....

Comments posted to this topic are about the item Too Many Choices

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;