MySpace successfully implemented a distributed database using Service Broker in 2009 to replace a very complex replication scheme. They were probably the majority, if not the sole...

This thread basically explains what I was thinking you would have to do but I would call it a workaround if anything...not really an elegant solution by any means.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d85668b6-2981-4b1c-978d-227483d03bae/%5B/url%5D

SSIS 2005 or 2008?

Is the database instance on Server1 a named instance?

Some things to look into:

Is SQL Browser running on Server1?

Is port 1434 open between Wrokstation1 and Server1? Use PortQryv2 to find out.

Does...

My fault. I knew the for each proc made use of EXEC and I did not know it would have access to temp tables declared outside the EXEC-scope. The real...

Looks like homework...

Lookup the NULLIF and COALESCE functions.

Elliott Whitlow (6/7/2011)

---

While it is possible to use a linked server in this case I would absolutely NOT do it. I used to be a BIG proponent of linked...

That's who I thought of first too and it's why I asked about current level...immersion training is not for beginners. I went to one of...

For this example you can use a simple UNION:

Setup:

IF OBJECT_ID(N'tempdb..#tbl') > 0

DROP TABLE #tbl;

GO

CREATE TABLE #tbl

(

foreign_curr CHAR(3),

local_curr CHAR(3),

period CHAR(2),

yr SMALLINT,

ytd_ave_rate...

The School of Hard Knocks is the best one I have found.

For formal training:

> Are you willing to travel?

> How long have you been working with SQL Server and...

Every iteration done inside the "for each" proc is done on an independent thread so you need to use a global temp table or a permanent table. Try it like...

Please post DDL for your tables, DML to add some test data that lets your query demonstrate the problem, and your expected results. If you're not sure what I mean...

Do tell why you decided to use a loop. Also, please provide the DDL for TableA and TableB.

Not...

Great, thanks Steve!