Search results for query: *

LFC: Thank you for your reply. That query will give me the orders that do have an invoice in a status of closed, but not give me the orders that meet the order conitions and have no invoice that is closed. I need all the orders that meet the order coniditions (o.status = 'closed' &...

I need help with the following query. I have two tables: 1) ORDERS(columns: fileid(pk), status, office, other fields) 2) INVOICES(columns: invoiceid(pk), fileid, status, date, amount, other fields) I can have multiple invoices for an order. I would like to select all the orders that match a...

I am trying to create a result set that will tell me how many open orders & the sum of revenue for those orders in inventory I had on the first of the month, for the last 13 months. An open order for inventory purposes are orders that were opened in the last 90 days and not been closed. So for...

New to SQL SRS - shifting away from CR in our applications. Is the below possible, and if so could someone suggest where to find information in how to implement the solution? We would like to be able to run an already existing report based on a SQL database event. When the event happens it...

New user to CR - still green. We use the Business Objects Infoview Website to schedule CR reports. I have a report called Open Orders. I would like to create one report that I can upload and then when I schedule it, I can pass it a parameter and based on that parameter it will run for a given...

We have a Toshiba Strata CTX100 in one of our locations :(, our vendor is having difficulty delivering what I think is a simple request. Is the following possible with this system and if so, what are we looking at. i have a PRI running into the device and i have 3 fax machines @ 3 different...

My forward no answer is set to 1638 which is our voicemail #. It is set for 4 rings. This is what is baffling me. Thanks.

Some of our extensions are demostrating some odd behavior. I am by no means an expert with the BCM200, but I do have a basic understanding. When a DN is on the phone with an outide party and they recieve another call, that new call is receiving a message that states 'The Person You Have Called...

Thanks for the help, what if we want to use this hunt group to provide backup for multiple lines? Meaning this same backup hunt group would cover a few phones and if the hunt group does not answer the call in the time frame can the call default back to the original line it came in on? I can...

New user here and I apologize if this is a simple question. We would like to set up our BCM system to do the following: A call is recieved on a Direct Dial line, it is not answered in X rings, it then rolls over to a Hunt Group, if it is not answered in Y seconds the call should go into the...