Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages. The benefit to using it is the nice user interface that a wizard provides. The disadvantage of using it is it’s lack of flexibility. When using the Deployment Manifest keep in mind...
2009-07-07
1,458 reads
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten you on what Checkpoints are and why it is beneficial to use them. Also, I will walk you through a basic example package where they...
2009-06-25
3,892 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Comments posted to this topic are about the item More Funny SELECTs
Comments posted to this topic are about the item Reducing the Cycle Time
I've set up replication in my SQL 2019 environment in attempt to migrate SQL...
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers