A Case FOR Cursors...
We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."
2016-09-09 (first published: 2015-06-01)
13,559 reads
cursors
Performance Improvement for Cursors in Stored Procedures
Exploring some differences between using cursors, local fast forward cursors and using set logic.
2016-11-11 (first published: 2015-02-03)
16,943 reads
Cursor-Killing: Retrieving Recently Modified Data
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.
2014-06-02
7,024 reads
A simple T-SQL statement to create a list of lookup values
In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.
2012-09-28 (first published: 2011-03-21)
34,321 reads
What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)
Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.
2010-09-01
5,122 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
42,583 reads
Avoiding cursors with SQL Server 2005
Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.
2009-03-19
5,627 reads
Cursors for T-SQL Beginners
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
23,091 reads
2010-06-23 (first published: 2008-12-24)
37,384 reads
Create Sample Data Script
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
701 reads
Blogs
Dealing with Changing Data Formats: Schema Drift in Azure Data Factory
By Rayis Imayev
(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...
Adding Manual Relationships Between Tables in the TDM Subsetter
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
The hell of Git line endings and the (not so) simple fix
I wrote a stream-of-consciousness post a few months ago about what I do in...
Forums
Do You Folks Mind Beginners Here?
I'm a retired IT guy in his 80s fighting boredom by trying to learn...
Do You Folks Mind Beginners Here?
I just joined and posted a brief profile. This is my first post. Please...
ROWID in MS SQL
WHERE a.ROWID IN (SELECT rid FROM ( SELECT ROWID rid, row_number() OVER (PARTITION BY...
Question of the Day
The Rank Window
I have this table and data:
CREATE TABLE [dbo].[SalesTracking]
(
[SalesDate] [datetime] NULL,
[SalesPersonID] [int] NULL,
[CustomerID] [int] NOT NULL,
[PONumber] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paid] [bit] NULL,
[total] int
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [SalesTrackingCDX] ON [dbo].[SalesTracking] ([SalesDate]) ON [PRIMARY]
GO
INSERT dbo.SalesTracking
(SalesDate, SalesPersonID, CustomerID, PONumber, paid, total)
VALUES
('2024-03-15 10:45:55.067', 1, 1,'PO965' ,1, 100),
('2023-09-24 10:45:55.067', 1, 2,'PO627' ,1, 200),
('2022-07-02 10:45:55.067', 1, 3,'PO6' ,1, 300),
('2022-11-03 10:45:55.067', 1, 4,'PO283' ,1, 400),
('2022-11-26 10:45:55.067', 1, 5,'PO735' ,1, 500),
('2023-04-28 10:45:55.067', 1, 6,'PO407' ,1, 600),
('2022-09-09 10:45:55.067', 1, 7,'PO484' ,1, 700),
('2024-03-13 10:45:55.067', 1, 8,'PO344' ,1, 700),
('2024-04-24 10:45:55.067', 1, 9,'PO254' ,1, 800),
('2022-06-19 10:45:55.067', 1, 10,'PO344',1, 800)
GO
When I run this query, how many unique values are returned for the SalesRank column?
SELECT
st.SalesDate
, st.SalesPersonID
, st.total
, RANK () OVER (PARTITION BY st.SalesPersonID
ORDER BY st.total desc) AS SaleRank
FROM dbo.SalesTracking AS st;
See possible answers