I'm not sure I totally understand the problem as presented. Are ID and ope_number the only columns that can be different?

I think the EXCEPT operator could be your friend...

Koen Verbeeck (5/13/2014)

---

It doesn't matter if the connection that creates the temp tables is disconnected before...

This is something I've often thought about. Not having a degree in computer science, engineering, or math, I've found myself behind in theory which, at times, has led to...

Koen Verbeeck (5/12/2014)

---

Jack Corbett (5/12/2014)

---

What do you mean by "the Wizard"? The import/export data wizard in SSMS?

I think what you will need to do is to code...

Jonathan Kehayias has a query on this blog post[/url] that identifies parallel plans in the cache which can help you start tuning the SQL that might be causing the CXPACKET...

It makes sense to me that adding indexes would greatly slow down replication. Think about it, for each index SQL Server has to make a copy of the data...

Pretty sure you are stuck. I'm not sure how SSRS would tell Excel the size that column needs to be for each row.

have you tried referencing the textbox that contains your totals using the ReportItems collection?

What do you mean by "the Wizard"? The import/export data wizard in SSMS?

I think what you will need to do is to code the package in BIDS/SSDT-BI and when...

bsr.anwar (5/8/2014)

---

I created the trigger successfully but when I tried to update the table the query doesn't execute it prints out

error stating that

Msg 15281, Level...

Carlton,

I'm sure you could have the Script Task (Component) do it. You would need to to be a destination and not a transformation and then make sure you handle...

I think this is what you need:

=Round(

(

IIF(Fields!STypeName.Value <> "SS" AND Fields!STypeName.Value <> "UA",

Fields!SDuration.Value/2,

SUM(Fields!VDuration.Value + Fields!SDuration.Value))

/60

)

,2)

This does:

IF Fields!STypeName.Value is not equal to "SS" or "UA" THEN

...

Good editorial today. I want 3 things from a manager:

1. Direction - I don't always want to be picking my tasks, I want to know what needs to...

David Burrows (5/7/2014)

---

Not that I would normally disagree with a master 🙂 but my second...

Accidentally hit quote on my own post and can't delete it.