Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jotb
Starting Member
6 Posts |
 Posted - 2010-01-04 : 16:37:49
|
| The problem is there are 4 fields for the jockey’s, the procedure for converting the names is no longer doing what it was supposed to, so I have a lot of weird names. These errors go back to the beginning, 1999, from the procedure that was used. A lot of the names were split into a redundant format.Eg. Some names with JR. Were split as if JR is their first name. The problem I have 6500 records just on jockey’s and what ever changes I make have to be carried back to all the entries and results.I can simply send the data and the procedure and maybe someone can figure out how to fix it.I need to make a new table from the old data. If this is done then some of those reports that didn’t work before should start working. I appreciate any help offered.Thank you in advance,Jotb |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-04 : 17:03:21
|
So you mean there is a procedure running since 1999.This procedure is splitting a name from one column into four columns.The splitting was wrong.What you have is:- the four columns with the results from that splitting procedure.- the code of the splitting procedure.What you want is that someone reads the code, sees the four columns and is able to undo the splitting.Is that right?Do you have the values from before splitting?Are you able to post us some samples?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-04 : 17:42:43
|
| and...it took 10+ years for someone to decide to fix it? lol |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-05 : 03:21:26
|
quote:
Originally posted by jotb
The problem is there are 4 fields for the jockey’s, the procedure for converting the names is no longer doing what it was supposed to, so I have a lot of weird names. These errors go back to the beginning, 1999, from the procedure that was used. A lot of the names were split into a redundant format.Eg. Some names with JR. Were split as if JR is their first name. The problem I have 6500 records just on jockey’s and what ever changes I make have to be carried back to all the entries and results.I can simply send the data and the procedure and maybe someone can figure out how to fix it.I need to make a new table from the old data. If this is done then some of those reports that didn’t work before should start working. I appreciate any help offered.Thank you in advance,Jotb
do you have original data somewhere (before splitting)?else we might need to first join splits to get original values and then split them again correctly |
|
|
|
jotb
Starting Member
6 Posts |
Posted - 2010-01-05 : 20:27:56
|
quote:
Originally posted by webfred
So you mean there is a procedure running since 1999.This procedure is splitting a name from one column into four columns.The splitting was wrong.What you have is:- the four columns with the results from that splitting procedure.- the code of the splitting procedure.What you want is that someone reads the code, sees the four columns and is able to undo the splitting.Is that right?Do you have the values from before splitting?Are you able to post us some samples?
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
jotb
Starting Member
6 Posts |
Posted - 2010-01-05 : 21:06:23
|
| The system was developed approx 10 years ago. The data was set up differently. The data source just changed recently and the old procedures have screwed up the data.I had 4 columns in the table:4Entries, 4Results, LastnameFirst, AbbrevLast FirstThe entries used to come in as the full name, which were matched to the name format for results which came in Lastname first.Now the entries come in as, the first names abbrev. only and the results come in as the full name , but firstname then lastname.This has made a complete mess out of my data, now there are at least 3 versions of the same name.My dilema is, there has been a few name format changes before which the table has been corrected for. Now I need to delete the duplicates and put into a table that will reflect all the other formats the names have come in without losing valuable info.So whatever changes I make have to be reflected back 10 years in 4 other tables.Also the length of some of these names is an issue, for example"Ishua M. Diaz Fergosa" now comes in as "I M Diaz Fergosa" in Entries and comes in as "Diaz Fergosa, Ishua" for results.There are also a lot of names with "sr,jr,d,la,III" etc.I hope this gives a better idea |
|
|
|
jotb
Starting Member
6 Posts |
Posted - 2010-01-05 : 21:16:14
|
| Yes I do have all the original data before the splits, the problem is this database is 40gigs.So sending back and forth is not an option. Though I am will to supply samples so that you can see the problem. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-01-05 : 21:25:23
|
can you post- sample of original data before splits- current result of split- desire result of split- the Splitting procedure
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
jotb
Starting Member
6 Posts |
Posted - 2010-01-06 : 16:48:27
|
| How do I upload a file here? I see an email or code or a pic but no way to upload a file. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 00:40:26
|
| you can upload it in public share and post link here |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jotb
Starting Member
6 Posts |
Posted - 2010-01-07 : 02:36:57
|
| The following is a small sample of code.The top part is what happened the last month. I used to get my entries from 2 sources, one with the full name and one with just the intials.Now my data source with the full name is gone, so I only get the initials and last name.The lower part is what happened a few months ago when I still had both data sources for the entries but one changed to just the intials.I hope this is readable if you copy it into excel it will be easier to read.JkyName4Ent JkyName4Res JkyNameLF AbrevLFA Bautista Bautista, A. A Bisono Bisono, A. A Bocachica Bocachica, A. A Canchano Canchano, A. A Cintron Cintron, A. A De Leon De Leon, A. A Garcia Garcia, A. A Gonzalez Gonzalez, A. A Kato Kato, A. A Landeros Landeros, A. A Leon Leon, A. A Mariano Mariano, A. A Mawing Mawing, A. A Peralta Peralta, A. A Rios-Conde Rios-Conde, A. A Rojas Rojas, A. Emma Jane Abbott Abbott, E.J. Abbott, Emma Jane Abbott, Emma Becky Abernathy Abernathy, B. Abernathy, Becky Abernathy, BeckyHarriet Abrahamson Abrahamson, Harriet Nobel Abrego Abrego, Nobel Abrego, NobelE Aceves Aceves, E Eddie Aceves Aceves, E. Aceves, Eddie Aceves, EddieR Aceves Aceves, R Rodrigo Aceves Aceves, Rodrigo Edgar Acosta Acosta, E. Acosta, Edgar Acosta, EdgarJ D Acosta Acosta, J D J. D. Acosta Acosta, J.D. Acosta, J. D. Acosta, J. Jeremy Acridge Acridge, J. Acridge, Jeremy Acridge, Jeremy |
|
|
|
|
|
|
|
|
Someone With SQL Experience