How to detremine... randomly! Doesn't matter wich 3 are remaining.
Table descrition:
PHone number|Company|Name
111|me inc.|John
111|me inc|Mark
111|me inc|Bob
111|me inc|Bill
112|you inc|fred
112|you corp|Ron
113|them|William
...
I would like to keep 113, all 112 and only 3 of the 111, doesn't...
Hello,
I've got a database with a lot of identical number but with different other information in the record.
As I have more than 3 times the same number I would like to take the 3 first and delete the others.
How can I do that?
Could you help me asap?
How to transform a table containg multiple records with a same name into a table with one record with a lot of field
example:
1|a
1|b
1|c
2|d
2|e
...
Become
1|a|b|c
2|d|e
...
Found it was a cni problem!
But as I try to test it, it failed and my system went down.
My PS 4 is group 2 and so refers to CNI in slot 13.
I've change both CNI cards and error persist.
I've also change PS card without any change.
The last thing I've to do is to change associated 3PE card...
I've already change the per sig without changes!
I try to make a Test CPU (ld 135) with this result:
HWI534 CMB: Synchronization of memories begun: CP 1 master
BUG6247 EvtColl: AAL file access error.
HWI533 CMB: Synchronization of memories completed
Then I try to switch CPU (overlay 135 SCPU)...
It's in "disable not responding" status!
I remove the card and put it back...
I change the card by a new one...
I restart the 3PE card...
I verify the connection between 3Pe and CNI...
I test and verify CNI cards...
and nothing!
I'm perplexed!
Hi,
I see this morning one of my msdl card in
"SYS DSBL - RECOVERY THRESHOLD NO RECOVERY UNTIL MIDNIGHT"
status!
I need this card before. Do you know the way I can enable my msdl asap?
I try to remove the card and set it back but the status remains...
Hi,
I'm a looking for a virtual printer that allows conversion to tif (g3 fax compression).
The printer I'm looking for has to work at least under Ms XP, millenium, 2000 and be able to offers the choice for resolution (dpi 200x200, 100x200,...)
Hi,
I'm trying to connect my MMCS to an other one just like any other carrier!
But doing so, I always receive a DTA300 errors...
How to configure or synchronize both side to have a working link?
Yes I do. My path is defined in another part of my script.
I use Procomm / Aspect 2.11. Is it possible that the script works with newer versions and not with this one?
No! In this case my file name is an automatic file name. It's a code (FR1 or BE1) with the full date (yyyy/mm/dd). Here is my script:
proc DateName
param string CapFileName
string CapPref, CapDate, TempVar1, TempVar2,TempVar3
CapPref = "FR1" ;Add an...
Hi all,
I wrote a script to give an automatic filename to a capture file.
The name I wish (because I must have) contains 11 characters (like: CODyyyymmdd) but system seems to allow only 8 characters lenghtwise filename.
Is it possible to bypass this rule?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.