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 |
|
whitmoj
Yak Posting Veteran
68 Posts |
 Posted - 2009-10-09 : 02:54:34
|
| Here is a good one I have been pondering on this one for a couple of days now. I update a table with agent ID's and Team Managers from 2 other tables on a seperate server. My problem is that after the Managers name I have Site and TL. see example. I am looking at a way of removing this. Can any one help?????Julie Bayliss Dudley TLWhitmojIf I have inspired one person today then my job is done. |
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-10-09 : 03:12:28
|
| All of the Managers name are in the same format?(only two parts delimited with a space) ? or do you have any other fields in any other table where you get only the managers name (which is same as the name part in your problematic field) ? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-09 : 03:16:11
|
| Post some sample data with expected resultMadhivananFailing to plan is Planning to fail |
|
|
|
whitmoj
Yak Posting Veteran
68 Posts |
Posted - 2009-10-09 : 03:23:15
|
| Here you go Ignore the last 3 columns as they are updated after and link to column 11007235 HEWITE Emma Hewitt TL Dudley DULLEN DUDLEC -979797770751.01007405 DUNNB Ben Dunn TL Dudley BROADD DUDLEC -979797770623.01007412 HEWITE Emma Hewitt TL Dudley DULLEN DUDLEC -979797770751.01007415 DUNNB Ben Dunn TL Dudley BROADD DUDLEC -979797770623.01007419 HEWITE Emma Hewitt TL Dudley DULLEN DUDLEC -979797770751.01007470 DUNNB Ben Dunn TL Dudley BROADD DUDLEC -979797770623.01007605 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02000162 OXLEYL Louise Oxley TL Sheffield ROCKJ SHEFFC -979797716167.02000379 SCTL Sheffield CSC TL SHEFFC NULL -979797716341.02000410 DUDLEP Paul Dudley TL Dudley DULLEN DUDLEC -979797770727.02000886 AMGREE Ann Marie Green TL Mailbox MAILCO MAILBO -979857855341.02000932 DOBSON Neil Dobson TL Sheffield RUSHIM SHEFFC -979797716307.02001 ACADTS Academy Tees Ret NEWTS TEESS -989896498114.02001021 PARRYJ Joanne Parry TL Sheffield ROCKJ SHEFFC -979797716172.02001187 MTL Mailbox TL MAILBO NULL -979857160095.02001460 SHORTO Scarlett Horton TL Mailbox MAILCO MAILBO -979857855332.02001772 SCTL Sheffield CSC TL SHEFFC NULL -979797716341.02001779 JONESK Karolyn Jones TL Sheffield RUSHIM SHEFFC -979797716329.02001889 SMARTV Vicki Smart TL Dudley BLACKL DUDLEC -979797770703.02001893 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02001903 COTTLM Michelle Cottle TL Sheffield BEEKSC SHEFFC -979797716126.02001915 JONESK Karolyn Jones TL Sheffield RUSHIM SHEFFC -979797716329.02001996 HAMILS Sondelle Hamilton TL Sheffield ROCKJ SHEFFC -979797716151.02002 ACADTS Academy Tees Ret NEWTS TEESS -989896498114.02002116 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002126 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002158 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002166 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002168 DCTL Dudley CSC TL DUDLEC NULL -979797770773.02002173 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002432 SSECON Sheff Secondment SHEFFC NULL -979761446060.02002439 HAMILS Sondelle Hamilton TL Sheffield ROCKJ SHEFFC -979797716151.02002441 OXLEYL Louise Oxley TL Sheffield ROCKJ SHEFFC -979797716167.02002669 FDOUGL Fiona Douglas TL Mailbox MAILCO MAILBO -979857855350.02002700 SCTL Sheffield CSC TL SHEFFC NULL -979797716341.02002707 OXLEYL Louise Oxley TL Sheffield ROCKJ SHEFFC -979797716167.02002762 WEBSTB Bruce Webster TL Sheffield RUSHIM SHEFFC -979797716310.02002815 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002818 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002827 DUNNB Ben Dunn TL Dudley BROADD DUDLEC -979797770623.02002836 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002849 DLEAVE Dudley leavers DUDLEC NULL -979797770761.02002850 NORTHP Paul Northall TL Dudley BROADD DUDLEC -979797770619.02002878 BAXTES Samantha Baxter Tl Sheffield ROCKJ SHEFFC -979797716165.02003 ACADTS Academy Tees Ret NEWTS TEESS -989896498114.02003024 SLEAVE Sheffield Leavers SHEFFC NULL -979797716339.02003087 BAXTES Samantha Baxter Tl Sheffield ROCKJ SHEFFC -979797716165.0WhitmojIf I have inspired one person today then my job is done. |
|
|
|
|
|
|
Word removal