Technical Article

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

The challenge is to write a query that returns the articles to be displayed in the home page of the website. N number of articles from each category is to be selected where N is configured in the Categories table. Each category should select the most recent N articles. ArticleID can be used to identify the most recent articles. An article with a higher number indicates a more recent article.

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Jayakarta HUB/WA 08216977701

By marinasuites

Jl. Pangeran Jayakarta Dalam No.26 Blok A/2-3, Mangga Dua Sel., Kecamatan Sawah Besar, Kota...

BCA KCU PLUIT No tlpon:083138717148

By labmate

Whatsapp:083138717148. Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta City, Jakarta...

BCA KCP Suniaraja No.Telp:087757645171

By canary bird sale

Whatsapp:087757645171 Jl. Suniaraja Timur No.49, Braga, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40181

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers