Using the MERGE Statement in SSIS Via a Stored Procedure
Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.
2012-01-23
13,341 reads
EDW
RE: Query to get first number
Try this... SELECT ISNULL(min(BudgetId), ISNULL((SELECT max(BudgetId) + 2 FROM tblBudgetYear), 2) - 1 FROM tblBudgetYear t1 WHERE NOT EXISTS (SELECT 1 FROM tblBudgetYear t2 WHERE t2.BudgetId = t1.BudgetId - 1) AND t1.BudgetId > 1
2003-08-29
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers