oyster

Phew - that is much better:cool:

Seems like a pivot would probably work for what you have described.

You can see an example here. http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

With a table structure (ddl) and more consumable data, somebody could probably help...

Good info. Thanks for posting back with your resolution.

LutzM (8/12/2014)

---

If that's the case, why isn't Oracle listed as a required qualification?

Or do you mean they're asking for a SQL Server...

LutzM (8/12/2014)

---

That's weird:

and

QUALIFICATIONS: Highly experienced in Database design and Administration performing the following:

• Expert...

http://www.amazon.com/Server-2012-T-SQL-Recipes-Problem-Solution/dp/1430242000

Nothing was said about using a SQL Script (exeucte sql component). Your data source (ole db source) can use a sql statement/query...

If you need replication, why not just upgrade and get a SQL Server Standard edition license?

daniarchitect (8/12/2014)

---

I like what I do , but don't get me wrong I want to make more money while the time is right:) . that's why move to different technology...

No, you just map the datasource column to the CurrencyCodePurchased column in your destination object.

Ed Wagner (8/12/2014)

---

jasona.work (8/12/2014)

---

So we had some torrential rain yesterday (up to 6" in some places in a couple hours, more than double the normal rainfall for August) Roads...

Lynn Pettis (8/12/2014)

---

Well, I know at least one person who is totally lost...

GilaMonster (8/12/2014)

---

So three days after implementing replication, I have a pile or replication-related errors on my desk (cannot truncate table because it's replicated, lob size exceeds max replicated text size)

How...

SQL Developers can go quite a ways - depending on their skill set. Just the same as with the other technologies - it depends on your ability.