ALZDBA (7/17/2011)

---

+1 because of the lack of...

Reading Jamie's blog has sent my brain's CPU to 100% at times (so has reading Paul's for that matter) but my computer has never had an issue 😛

Seriously though, maybe...

Can you? This would seem like Option (i.e. workaround) #3. The filtering is not technically part of the OUTPUT clause but it will...

Welsh Corgi (7/16/2011)

---

Welsh, what the H*(&^ are you talking about? 😛

Me too, every day mate...happy you got it sorted 😎

That's not how the OUTPUT clause works: http://technet.microsoft.com/en-us/library/ms177564.aspx

To achieve the behavior I see a couple options:

Option 1: issue two inserts

- Insert 1: insert into tblProduction WHERE col3 <> 0...

WebTechie38 (7/16/2011)

---

Thanks for the outline.

I was wondering how if you had an example or knew of an example for number 3.

I haven't done that before. I would...

I would recommend you have a look into Synonyms and Views.

Both can perform cross-database operations and can be dropped and recreated in the context of a transaction so you could...

No worries. Please refer all comments to the other thread going forward. I think the comment I made on the other thread will help you solve the issue without using...

naveen0905 (7/16/2011)

---

Hi Guys,

I have sample data like mentioned below.

Student IDattendancefrom_dateto_date

1 20 1/1/20102/1/2010

1...

Is this the same issue as this or am I missing the nuance?

http://www.sqlservercentral.com/Forums/Topic1142962-391-1.aspx

Here is a rough sketch of an SSIS package that will do what you want:

1. Load the list of instances you want to iterate over into SSIS however you're doing...

I was able to get something going. The issue changed for me when I reworked the DllImport for LoadLibrary (Reference).

Pre-reqs I had to satisfy to deploy UNSAFE assemblies:

1. Alter...

You're welcome Hawaiian! I am happy it will work for you...enjoy the weekend 🙂

Jeff Moden (7/15/2011)

---

opc.three (7/15/2011)

---

Very nice job posting usable DDL, DML and what you have tried! Provide your desired output relative to the same test data please and we'll see if...