Using the Public Role to Manage Permissions
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,426 reads
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,426 reads
Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!
2001-05-02
8,246 reads
Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.
2001-05-02
5,841 reads
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,451 reads
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,551 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