Viewing 15 posts - 13,816 through 13,830 (of 15,381 total)
Stefan Krzywicki (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting older...
October 6, 2011 at 12:20 pm
Grant Fritchey (10/6/2011)
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting...
October 6, 2011 at 12:13 pm
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...
October 6, 2011 at 10:48 am
I think that works with a minor caveat, this only works when there is one UserID in the table.
October 6, 2011 at 10:30 am
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...
October 6, 2011 at 10:20 am
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...
October 6, 2011 at 9:51 am
david-1019744 (10/5/2011)
Spend some money and buy a copy of 'Trees and Hierarchies in SQL for Dummies' by Joe Celko - it covers this topic in some detail.
You do realize this...
October 6, 2011 at 9:13 am
grant execute on StoredProcName to User
October 6, 2011 at 9:03 am
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...
October 6, 2011 at 9:02 am
kramaswamy (10/6/2011)
The records that are Type = 1 are the ones which...
October 6, 2011 at 8:25 am
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...
October 6, 2011 at 8:13 am
khushboo.dudani (10/6/2011)
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...
October 6, 2011 at 8:08 am
sunny.tjk (10/5/2011)
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...
October 5, 2011 at 3:25 pm
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...
October 5, 2011 at 3:17 pm
Viewing 15 posts - 13,816 through 13,830 (of 15,381 total)