What you have tried so far? Thanks for showing your desired result and some info about the source data. So I can provide tested code, please provide a CREATE TABLE...

himanshu.sinha (2/13/2016)

---

Working on a script to restore a backup file which is on server A & restore it on server B .

These are the steps which needs to...

Steve Jones - SSC Editor (2/13/2016)

---

Orlando Colamatteo (2/13/2016)

---

Thanks for leaving out a bunch of steps to get to the eventual solution (like creating the cert and opening the key). Forced...

This query form produces a slightly (6% better) cheaper plan than the one you posted (and the query is a bit easier to understand in my opinion) but a cheaper...

What made you add the ORDER BY?

I am showing three CI scans in the estimated plan on EARLY_PAYOFF_INFO_PK but I do not have your statistics so things may look drastically...

Thanks, but that was a mess...

For those who want to actually compile the schema:

CREATE TABLE [dbo].[ADDRESS]

(

[ADDRESS_ID] [int] NOT NULL IDENTITY(1, 1),

[LAST_MODIFIER] [int] NOT NULL,

[LAST_MOD_DATE_TIME] [datetime] NOT NULL,

[TRANS_SEQ_NUM] [smallint] NOT NULL,

[ADDRESS_LINE_1]...

Please post definitions including indexes and constraints for all tables involved.

Thanks for leaving out a bunch of steps to get to the eventual solution (like creating the cert and opening the key). Forced me to do a bit more research.

Because we can, of course!

And this:

Steve Jones - SSC Editor (1/4/2016)

---

PoSh might be more convenient if you were deploying this across...

Please post both source and destination table definitions as well as the complete error message or an SSIS Package that shows the behavior.

This is a common requirement. What you are wanting is a Drillthrough Report.

Nice and neat. Very useful. Thanks for sharing. I did something similar while back that delivers a single resultset. It's under the "Analysis" section in this article[/url].

I would follow along the same line of thinking that Scott has laid out. One minor thing I would add to step 3 for consideration:

3) copy the data in batches...

You posted to a thread that was 5+...