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: )

405 reads

Blogs

Using Git Prune–#SQLNewBlogger

By

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Microsoft Purview new data governance features

By

Starting last week is a rollout of the public preview of a new and...

SQL Database Administration: Not For Everyone (But Maybe It’s for You)

By

Let's get one thing straight: database administration isn't the most glamorous tech job out...

Read the latest Blogs

Forums

SSRS Expression IIF Zero then ... Got #Error

By danyeungw

Hello, Need some help for SSRS. The column % expression is =iif(sum(Fields!ColumnA.Value) = 0...

Insert using table unput

By Bruin

I have a table that I need to run off a different server\db and...

zero downtime deployments

By sqlguy80

Hello, We have azure MI business critical. active read/write, secondary read /only. from what...

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers