May 26, 2009 at 12:21 pm
Rod Carter (5/26/2009)
Thanks to all!! The @NewDateTime = [time_entrydate] = was the part that I was missing. I could not get the thing to re-assign the new values. As always, simple when you are shown the way.Sorry for all the confusion in the earlier posts.
In case of problems, please be sure to test in a development environment. please let us know if you get the results you expect (or don't).
May 26, 2009 at 1:50 pm
Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company. As such, the time itself will not be unique. I can use a temp table instead of the table variable so I can combine columns to get a unique index. Just thought I would ask first.
May 26, 2009 at 1:59 pm
Rod Carter (5/26/2009)
Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company. As such, the time itself will not be unique. I can use a temp table instead of the table variable so I can combine columns to get a unique index. Just thought I would ask first.
Which is why you really should provide the full requirements for your problem instead of trying to simplify the problem. Unlike some gurus here that can answer a question based of minimal info, I need to see what you are working with to really be able to answer your question.
May 26, 2009 at 5:11 pm
?second iteration Lynn 😉
May 26, 2009 at 9:03 pm
Allister Reid (5/26/2009)
?second iteration Lynn 😉
Only if the OP provides the full requirements.
May 26, 2009 at 9:11 pm
Rod Carter (5/26/2009)
Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company. As such, the time itself will not be unique. I can use a temp table instead of the table variable so I can combine columns to get a unique index. Just thought I would ask first.
Rod, First I recommend that you read the first article I reference below in my signature block about asking for help and follow the guidelines when asking for help on problems such as this one. Second, I then recommend reading this blog entry to understand why, The Flip Side.
May 27, 2009 at 4:44 am
Lynn,
I will do both and thank you for your feedback and help to this point. I truly do appreciate it and am not trying to be difficult. I am under a time constraint and mistakenly thought that simplifying would speed the process. This is obviously and incorrect assumption and caused you grief. My apologies.
May 27, 2009 at 6:43 am
Rod Carter (5/27/2009)
Lynn,I will do both and thank you for your feedback and help to this point. I truly do appreciate it and am not trying to be difficult. I am under a time constraint and mistakenly thought that simplifying would speed the process. This is obviously and incorrect assumption and caused you grief. My apologies.
Rod,
No grief here, just that if you don't provide the full details and requirements it is hard to provide you with a complete answer to your situation. If you are able to take a simplified answer and put it to use that's great, but if you have to come back asking more questions because the actual problem is more difficult as there are additional requirements to get it to work, then more time is used answering additional questions that could have been answered earlier in the process.
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply