Search results for query: *

I have a Table with a list of Defendants in legal suits. I have a report that goes out and one of the fields in the report needs to be a 1 = Loan Signer being sued, 2 = Co-signer of loan being sued, or 3 = Both loan signer and co-signer are being sued. Each record contains a unique field call...

Hello, The following query I'm trying to run takes a really long time. I waited 45 mins and gave up. I need this to run and return the results as quick as possible. The SCACCT Table contains approximately 1.6 Million Records and the SCPAYM Table contains approx. 150,000 records. Here is...

Hello All, Here's what I got. TableA contains A list of phone numbers with area codes as so "9545551212". TableB has a list of area codes like 954 561 305 and so on. I need to compare the area code in TableA with the area codes in TableB and...

Hello, How do I remove duplicate records from a table? I am comparing two tables by customer SSN and the results return several duplicate records. Can some one post a reply that can remove the duplicates prior to dumping my results? Here is a copy of my Query Below: SELECT *...

Hello All, I have a Windows 2000 Server SP4 and when I try to go to the network properties nothing happens. I needed to change a static IP and had to do it using the command prompt using "netsh". Quite a useful command, but I had never used it until now. I also cannot access any web using...

I have a MICS 6.0 and Call Pilot 100 w/AA enabled. Operator phone is 240. Set to forward no answer to 248. 2nd Operator phone is 248 set to forward no answer to 231. Those two DN's are assigned to the GD mailbox. The receptionist at x.240 has been complaining to me that calls are going...

I have extension 229 as an Answer DN for 230. 229 forwarded thier phone to voicemail. Now when a call goes to 230 it goes straight to 229's voicemail. 230 is only set to go to voicemail on no answer. Even then it has it's own vmail account. Anybody ever have this happen before? Thanks, John

Hello all, I have call screen enabled on the call pilot for several of the managers. Before we moved the phone system to a new location it worked fine. Now even if that manager has Hard Forwarded thier phone to voicemail the call screening bypasses and rings through. It never did that...

Hello, Can I just power down the system, slap the NVRAM into a notebook PCMCIA slot and copy the data over? Or do I need to buy a special mod to attach it to a standalone pc or network then do it? We are moving our business to a new location and I wanted to be safe. Any help is...

Hello All, I have a bunch of the M2008HF Meridian Phones. Several are brand new. Will they work on a MICS w/6.0 Software? Does anyone know if it will work on any MICS system? I dont want to dispose of them if we can keep them for ourselves. Thanks, John

Hello All, I have a hunt group called HGSALES on ext. 707. On a users phone there is one button that flashes when a call comes in on the group. I would like to have a second button if at all possible. Any help is appreciated. If provided info is not enough please let me know. Thanks, John

Hello, I have a sales team in a huntgroup. Sometimes people call a rep directly. Here is a scenerio that I am having trouble with. A caller calls in and speaks with the operator. The caller asks to be transfered to Bob. Bob is on another call, but another sales person hears the quiet...

Hello, Currently I have 7 lines. All 7 lines are in POOL A. My phone company is also pooling our lines. Since I already have a line pool defined in my system, am I able to go ahead and cancel the phone companies line pool service. Thanks, John

Hello, I came into work this morning to having 4 out of 7 of my lines hung. When you press the line it just says in use. No station identification. I have a CallPilot 100, but am not sure if that was the cause. I also had one phone doing line redirection, but when I showed the line it said...

Hello, I have one computer on my network that cannot seem to logon to the domain. It's saying it does not exist or cannot be found. I can do the following: -Logon as local admin and ping the dns server. -I can resolve host names. -The client receives an IP address. What I did...

Hello, I currently have a Linux firewall and an ISA firewall. The ISA is new and I want it to be the primary and the only one. Everything seems to work fine when both are up as far as Web and Email goes, But when I took down the Linux firewall no one could access the Pop server from...

Hello, Here it goes. I have two tables: TableA and TableB. Both tables have a field named Inv_Part_Key that is the same on both tables as well as a field called Notes. The Notes field in TableA has data while TableB does not. How can I get the data from TableA, Notes to update TableB...

Hello, Does anyone know how to remove the first carriage return in a field? Also removing the data up to the first carriage return may be nice as well. Table Name = ADDRESS Column Name = STREET_ADDRESS The stree_address field contains a company name then a Carriage Return followed by a...

Hello, A co-worker had asked me if I can do a query to return every 50th record. I know it can be done, but I do not know how. I also need to return certain columns with each record returned. Any help is greatly appreciated. Thanks In Advance, John P.S. there are over 20,000 records.

Hello, I need to change the following data 'SHELF 123' to look like 'IC-SHELF-00123' The command I used to conver 'ROW 123' into 'IC-ROW-123' was as follows: UPDATE <TableName> SET <FieldName> = (Select 'IC'+'-'+ RTRIM(Left(<FieldName>,Convert(varchar,PATINDEX ( '% %' ...