Technical Article

Progressive Sums in T-SQL

A common problem in sql is how to calculate and process, for the current row, information that is based on the results (sum, product, difference, etc) of the rows read so far.A solution (we use) to this problem is to create a self join query based on the primary key using the condition of "greater […]

2 (1)

You rated this post out of 5. Change rating

2006-03-23 (first published: )

408 reads

Blogs

Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým

By

The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Read the latest Blogs

Forums

Copy Logins from on prem to Managed Instance

By BAM

Hello, I try to migrate SQL on Prem Instances to SQL Managed Instances. I'm...

Error while Simultaneous Switching and BCP in same table

By saum70

Hi, Our application is created in VC++. We have House keeping process in which...

Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Updating a Cryptographic Provider for...

Visit the forum

Question of the Day

Query Store for DDL

How do I configure Query Store to capture plans for CREATE and ALTER DDL commands in SQL Server 2022?

See possible answers