I agree with Grant's suggestion of using parameterized dynamic queries (sp_executesql).

This will reuse query plans even though the query is built dynamically.

Yup outer join will work.

I'm going to assume there's a unique EmpID per Employee.

You would need to have a month table with month name (and month number, if you need...

If you haven't already come up with a solution...

And you just need to examine execution plans of poorly performing queries , see here

You can just copy over the db schema...

Have you tried to convert to string first then to decimal?

Lucky!

We've been trying to get it, but obviously had to do without it so far...

I've never used it, but it sure would have save me a lot of time 🙂

If I understand your requirements correctly...

You should create just the structure of a customer's db (no data) and create SSIS jobs to populate it by taking a random portion of...

As Derrick mentioned...

To update the dev db can be a bit tricky and really depends on the dev team's requirements.

Does the dev team want to keep their inserts and updates?

If...

Here's a great article that can pretty much take you step by step on trouble shooting transactional replication performance.

http://blogs.msdn.com/b/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx

Just a shot in the dark...

Are all your file group stored on files on the 184GB hard drive?

What are their growth settings?

Without knowing what you've already tried, here are some suggestions...

Is there some kind of a condition defined on the Precedence Contraint?

Also, have you tried replacing your transformation script component with...

If you want any one of the failed insert to revert back other previous inserts, you do need to explicitly declare transactions.

Without using transactions...

You can have each insert lock one...

Do all the tables have different structure?

Dynamically create your queries using sys.tables and sys.columns.

You'll probably have to do something like this.

SELECT

CASE WHEN COL1 = @KEYWORD THEN COL1 + '|TABLE1.COL1'

...

inserted and deleted tables hold the changed data as a result set, not a single row.

Avoid the following code as it won't handle multiple updates.

DECLARE @insertedValue VARCHAR(10), @insertedID VARCHAR(10), @deletedValue...

If data type is DECIAL(9, 0), which means no decimals, then you can use the method suggested on previous posts.

SELECT

a.BAN,

a.ACC_TYPE,

a.ACC_TYPE_SUB_TYPE_DESC,

a.BL_MAJOR_ACCOUNT_NO,

a.ACTIVE_SUBSCRIBER_CNT,

s.SCS_PR

s.SCS_Manager_PR,

s.SCR_Manager_PR,

s.SCS_SR_Manager_PR,

s.SCR_SR_Manager_PR

FROM dbo.ndw_account_dim a right outer join dbo.sct_master_query s

ON a.BAN = s.BAN

WHERE...

Oh and what's precision and scale of the decimal? DECIMAL(?,?)