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...

villychilly (7/15/2011)

---

Hi again, and thank you both very much for your replies. I was obviously having a bit of a bad morning and Welsh Corgi, your reply kickstarted my brain...

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 we can assist.