Monday Morning Mistakes: Connecting to Wrong Environments
Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...
2012-06-18
2,317 reads
Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...
2012-06-18
2,317 reads
Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...
2012-05-21
1,180 reads
You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...
2012-04-30
2,967 reads
This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...
2012-04-23
1,084 reads
I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...
2012-03-21
904 reads
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,439 reads
SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...
2012-02-16 (first published: 2012-02-13)
4,116 reads
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes...
2012-01-23
986 reads
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
74,425 reads
This week we’re going to talk about a topic that has been gaining steam in the last few years and...
2011-11-17
1,159 reads
I wrote a stream-of-consciousness post a few months ago about what I do in...
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
Comments posted to this topic are about the item The Rank Window
Comments posted to this topic are about the item The End of Azure Data...
Comments posted to this topic are about the item How to Develop Solutions with...
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 ) 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) GOWhen I run this query, how many unique values are returned for the SaleRank 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