The most likely reason is that your interim result set has a column that is not being pivoted on nor in the final select list. PIVOT groups by ALL...

Your approach is fraught with problems. For example, what if the load fails on a Friday and you're trying to load it on a Monday? Yesterday's filename will...

bkubicek (10/11/2011)

---

I am not sure how you could get the min value from the outer join using a having clause.

You seem to be joining to the same table over and...

By default, an Execute SQL Task only returns success/failure information to the package. If you want to use the output of a result set, you need to specify the...

Your PARTITION BY is wrong. You want the last record for each Service_Tag, so the PARTITION BY should just be on the Service_Tag, and not on the Service_Tag, Employee_ID...

This is just a guess, but it probably needs consistent resultsets. That would mean no IF statements, no dynamic SQL, etc. In this particular example, you can replace...

Performace Guard (Shehap) (10/7/2011)

---

By this way , you have concluded the coding enhancement part , so what is next is the indexing enhancement part by implementing the below index :...

Now that you mention it, my trigger actually did the reverse. The person who designed one of the tables didn't normalize it properly. The trigger I wrote created...

I'm not sure that this is a T-SQL issue. You may have better luck posting in a forum for the application/language that you are working with. I did...

When doing UPDATEs, you should be aware that UPDATED() does not necessarily mean CHANGED. It simply means that a...

I don't think so, because of the following condition "clsdt_date = wrkcpl_date".

You can't do an index seek on cssdt_date until you know the values for wrkcpl_date. You can't do...

You're mixing the syntax for UPDATE and UPDATETEXT. You need to use one or the other.

text fields are being deprecated. You should consider changing it to a varchar(max)...

I'm getting 62 minutes. Which set of data are you using?

Drew

Here is code that gives the correct result for your sample data. From there, you should be able to figure out a way to optimize it.

;WITH PlannedWork AS (

SELECT...

I'm going to throw a wrench in the works. All of your data has had roughly equivalent start and end times for the planned and actual data. Suppose...