usp_TransposeNRows

Stored procedure to transpose the first N rows of a specified table

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2010-02-05 (first published: 2010-01-18)

1,107 reads

Blogs

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

I’m really excited about some growth in Flyway support. I’ve been asking about this...

"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...

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;