Clay Punnett

Find unused columns

Script finds all columns in a table that have a single value.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2016-11-28 (first published: 2016-11-21)

4,178 reads

We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...

Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...

Palantir is an American software platform that brings together business data from different sources...

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

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

Comments posted to this topic are about the item Table Partitioning in SQL Server:...

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;