December 7, 2009 at 10:46 am
Hello All,
I am looking for a way to renumber values in a table for a specific groups of data. For example, a process has 10 steps of which each step can have 1-to-n sub-steps. the original data looks like the following:
P1 - S1 - s1.1, s1.2, s1.3,..., s1.n
P1 - S2 - s2.1, s2.2, s2.3,..., s2.n,
but it was ELTd over as int, so the s-values are for S1 are all s1.
How can I update the values to be S1 - s1,s2,s,3,sN without having to go back to the original data to find the decimal number? At this point the sequence does not matter.
Thanks...MJ
December 7, 2009 at 10:51 am
Personally, I'd fix the ETL process and rerun it.
Not knowing the structure of the data (the tables) it may be a bit difficult to provide you a proper answer. Please read the first article I reference below in my signature block regarding asking for help. Following the instructions in that article will get you better answers as well as tested code.
December 8, 2009 at 8:56 am
I thought that would be the case and I will do that.
In reviewing the proper way to submit posts, I was able to figure out a way to handle the situation - using Row_Number() OVER...
Thanks...MJ
December 8, 2009 at 10:03 am
drxjuby (12/8/2009)
I thought that would be the case and I will do that.In reviewing the proper way to submit posts, I was able to figure out a way to handle the situation - using Row_Number() OVER...
Thanks...MJ
You aren't the first one to solve a problem while setting up the problem to post it. It does help focus your thoughts as you need to be sure to provide enough information for others.
Glad you were able to come up with a solution. 🙂
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply