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

Bank BCA KCP Suari Telp:cs.08218171955

By SURYA

Whatsapp:08218171955 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121

BCA Finance Bekasi Layanan Mobil. Tlp/wa:08218168235

By veby009@gmail.com

KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...

BCA KCP Pahlawan No. Telp 083139530154

By kgcvietnam

Whatsapp: 083139530154 Jl. Pahlawan, No. 17 Bandung, Jawa Barat, Indonesia 40122

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