Stefan Krzywicki (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older...

Grant Fritchey (10/6/2011)

---

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting...

Yeah I was originally thinking of going about this in blocks. Get the total minutes scheduled for each block then the number of minutes worked for each block but I...

I think that works with a minor caveat, this only works when there is one UserID in the table.

Do you have a way to tie the actual hours to the planned hours? I see a UserID which tells who the individual is but there is nothing that says...

Even with the correction I just can't come up with your 53 minutes. It just doesn't add up. The grand total here is only 3 minutes. Work block 3 and...

You do realize this...

grant execute on StoredProcName to User

The other problem I see with the data is that if only Type1 from Planned are scheduled work blocks there are only 3 of those in the PlannedHours table but...

kramaswamy (10/6/2011)

---

I'll have to check your query when I get to work, but no, the calculations I made were correct.

The records that are Type = 1 are the ones which...

Since you are still in 2005 (which means no merge statement) you could do this in two steps.

Obviously the update is pretty simple because it will only update those it...

khushboo.dudani (10/6/2011)

---

Hi James,

Thanks for your reply. But, I agree with Sean. Nevertheless, I implemented your suggestion. Inserting non-English characters from Memo field to nText field still inserts ??? in SQL...

sunny.tjk (10/5/2011)

---

Sean,

When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from...

Glad that worked for you.

Nice job setting up the data!!!

I don't think you desired output matches what you stated you want for expected results.

Row 1: From 8:00AM to 9:55 AM. Was supposed to work...