A Custom Execution Method – Level 19 of the Stairway to Integration Services
The next level of the Stairway to Integration Services looks at how you can execute your package.
2022-02-02 (first published: 2015-01-21)
8,035 reads
The next level of the Stairway to Integration Services looks at how you can execute your package.
2022-02-02 (first published: 2015-01-21)
8,035 reads
In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.
2021-04-21 (first published: 2015-07-08)
8,202 reads
In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.
2020-12-16 (first published: 2018-09-19)
4,203 reads
In this next level of the Stairway to Biml, we look at a custom framework in Biml.
2020-09-16 (first published: 2018-08-01)
4,451 reads
In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.
2020-01-15 (first published: 2019-09-04)
4,243 reads
In this next level of the Stairway to Integration Services, we look at the SSIS catalog environments and how they help you manage your package parameters.
2020-01-01 (first published: 2015-02-18)
30,956 reads
This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.
2019-12-04 (first published: 2018-10-10)
2,689 reads
The next step in the stairway to Biml teaches you how to build a basic SSIS package using the scripting language.
2019-11-27 (first published: 2013-07-31)
26,761 reads
An introduction to the Biml language from Andy Leonard that helps
2019-11-20 (first published: 2013-07-17)
46,525 reads
Learn the basics of data flow in SSIS with the data pump in this second installment of our series designed to teach you about Integration Services.
2019-05-10 (first published: 2011-02-17)
71,318 reads
By Brian Kelley
Digital exhaust, or data exhaust, is the information you generate as you interact digitally....
By Steve Jones
A recent change made to Redgate Monitor to add a new alert for VLF...
In this post, the fifth in our series, I want to illustrate an example...
Hi, Im unable to delete records from a table.Im a little surprised as have...
ED can take a toll on confidence, but Vidalista 40 mg tablets restore it instantly! With fast...
Comments posted to this topic are about the item Why use Tally Tables in...
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 , DENSE_RANK () OVER (PARTITION BY st.SalesPersonID ORDER BY st.total desc) AS SaleRank FROM dbo.SalesTracking AS st;See possible answers