I think David is right, either you are restoring on top of the original database in which case you need the WITH REPLACE option, or you are restoring on top...

You're talking about the email report, right? There is a button with a little report icon near the top (to the right of Manage Connections). Click that.

I haven't...

Then I think you can either upload the spreadsheet data into a table and do it all in one update query using a join, or create individual update for each...

Look up BEGIN TRANSACTION in books online for details and options for using transactions.

So for this specific example:

update Report_T set Cost_AM = 720.00, Total_Cost_RPS_AM = 830.00, EFFECTIVE_DT=getDate() WHERE SK_SEQ_ID=49

The "720.00"...

Or maybe you need three more MAX statements. Currently you have MAX(--4 case statements--). If instead you had MAX(case), MAX(case), MAX(case), MAX(case), you would have the 5 columns...

Is the cost information stored in another table somewhere where you could link it up using a join? If not, you could use a case statement to bring it...

Alright - just have to ask... saving to an SSIS stream was a red-herring thrown in to have another possible answer right? It isn't possible to save profiler traces...

Glad you got it working. Be careful with the ColumnsUpdated - my experience has been that it returns true if the column was part of the update, not if...

I think you select IS returning something and the DOS field is NULL in the record(s) that are returned. If no records are returned, nothing will be inserted (which...

No - a full backup does not truncate the log. The log and database backups are somewhat independant. When you backup the log, it will contain all the...

The order of a result set can only be guaranteed by using an ORDER BY. Although You might be able to get it to "work" again by rebuilding the...

How about any child objects (views, triggers, constraints, rules, defaults)?

Chad

Good Luck - one last thought before I go. I'm going to go way out here on a guess. Does your Excel sheet have one line for each...

Help me out here... is this a decent mock up of the tables in question (some columns removed)?

emp_id

pgb_idName

1Chad

2Frank

3Joe

emp_deduc

pdb_iddeduc_amt_per_deduc

110%

120%

130%

25%

310%

depend_demo

pdb_idName

1Jack

1Sam

2Tealc

2Daniel

Based on this information, there is no way to tell if the 10%...

Can you tell me how you know when a particular record in emp_deduc is for a dependant and when it is for the employee? It doesn't look like there...