Recent content by rwies

Thank you everybody who responded. It looks like my problem is solved. Ron--

Thanks for your assistance. The answers to everybodies questions: The number 99 is under dispaly capacity. The switch is a G3 SI The processor is a TN790 V12 The release is G3V6.1.03.0.223.5 Ron--

We have a G3 V6 system. Does anybody know how I can increase the quantity of VDN's allowed in our system? Our capacity shows a maximum of 99, we need more. Ron--

Thanks to everybody, I have solved the problem with some of the feedback from Tek-Tips. Ron--

You are right, it is a varchar field. Sorry for my error. Ron--

I have a database with address, number and street fields. The address field has to contain the full address. The number field needs to contain just the street number. The street field needs to contain the street. The address field already contains the complete address. I need to select the...

For this project, all I need to do is keep one row and delste the rest. It doesn't matter which ones get deleted or which one gets kept. There is a primary key automatically assigned with the insert. If I can figure out a way I will keep the lowest number in the series and delete the rest. Ron--

This greatly deepens the amount of information you have to understand. The initial code that creates the problem is: insert into dbo.AccountZoneTbl0 (AccountNumber, S_ActNbr, System_no, MAS_ZoneID, o_mas_zoneid, fmt, [Description], GroupID, zone_to_restore, DateTimeStamp, RestoreDelay...

I am working on a conversion and I have run into a problem concerning duplicate rows. I ultimately have to insert the data in the table where the conversion is being done into another table. In the new table three fields make up the primary key. Due to various factors the in the conversion...

Thanks to both bborissov and mrdenny. I appreciate your assistance. I got what I needed. Ron--

I need to run a select distinct from query analyzer to update a table. Below is my attempt that did not work. Any ideas? Thanks, Ron-- insert into dbo.AccountZoneTbl0 (acct_cancelcode, AccountNumber, S_ActNbr, System_no, MAS_ZoneID, o_mas_zoneid, fmt, [Description], GroupID...

John, I added the parentheses and the code ran without error. However, I don't see any change to the text. Michael is right, the code I am trying to chnge is similar to 1A234. I want it to be 11234 after running the code. There may be more than one letter in the text such as 1ca234. In...

Earthandfire & John, I changed the code to: DECLARE @asc tinyint SET @asc = 1 WHILE @asc <= 26 BEGIN UPDATE dbo.AccountMainTbl0 SET ID_no = Replace(ID_no, ASCii(@asc + 64), Cast(@asc AS varchar(2)) SET @asc = @asc + 1 END I then got the following error...

John, I pasted the following in Query Analyzer and tried to execute it: DECLARE @asc tinyint SET @asc = 1 WHILE @asc <= 26 BEGIN UPDATE dbo.AccountMainTbl0 SET ID_no = Replace(ID_no, ASC(@asc + 64), Cast(@asc AS varchar(2)) SET @asc = @asc + 1 END I got...

I have a situation where I have account numbers that contain letters. I need to change the letters to numbers creating an int value. I have several thousand account numbers to change and several different letters to convert. I would like to convert an "A" to 1, "B" to 2, "C" to 3, etc. Any...