Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PeteBull

    error - conversion of nvarchar to datetime data type

    Thanks for your help George. I have implemented your changes to the view and tested successfully. Best of all, I learned something new today.
  2. PeteBull

    error - conversion of nvarchar to datetime data type

    George, that worked like a charm! Thanks for all of your help in tracking this issue down. The offending row had a 00 in the month position. That row is gone now (no loss as the entire row was corrupt). I appreciate your offer to help with the view. Here are the date and time column for the...
  3. PeteBull

    error - conversion of nvarchar to datetime data type

    date = nchar(6) time = nchar(4)
  4. PeteBull

    error - conversion of nvarchar to datetime data type

    Here is the code for the view: SELECT cond_code, CONVERT(DATETIME, SUBSTRING(date, 1, 2) + '/' + SUBSTRING(date, 3, 2) + '/20' + SUBSTRING(date, 5, 2) + ' ' + SUBSTRING(time, 1, 2) + ':' + SUBSTRING(time, 3, 2) + ':00') AS Event_End, CONVERT(INT, LEFT(RIGHT('000000' +...
  5. PeteBull

    error - conversion of nvarchar to datetime data type

    Select system_type_id, is_computed From sys.columns Where object_id = object_id('table') and name = 'event_end' system_type_id = 61 is_computed = 0
  6. PeteBull

    error - conversion of nvarchar to datetime data type

    I am getting the following error message when attempting to sort results by a datetime column: "Msg 242, Level 16, State 3, Line 1 The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" here is the query: select top 100 * FROM [table] order...
  7. PeteBull

    Queue Limits

    I thought queue limit was only for attendant groups???
  8. PeteBull

    Avaya CM 5.2 w/SES integration with Exchange 2010 UM

    I was originally told by support that it was an ACK problem (on the OCS side), so it sounds very much like the problem I had with OCS (perhaps in reverse). I had to remove the codec from OCS though, not CM.
  9. PeteBull

    Avaya CM 5.2 w/SES integration with Exchange 2010 UM

    sorry if this doesn't help, but when I had an issue getting MS OCS 2007 Speech Server working with SES on my 5.2.1 system I had a talk path issue that ended up being a codec problem/mismatch. I had to remove the codec from the options on OCS. I wish I could remember which codec it was...
  10. PeteBull

    Avaya Software - help me understand software releases

    I think that starting with Definity Release 11 the product was renamed from Definity to Communication Manager, but the phone system software naming convention was the same, so Definity R011 was Communication Manager 1.0, etc. It is common for software companies to have a real name and a...
  11. PeteBull

    Avaya Software - help me understand software releases

    it looks to me like that system is running CM 5.1.2
  12. PeteBull

    Avaya Software - help me understand software releases

    If I remember correctly: R = Release 015 = Definity version 15
  13. PeteBull

    Station Form Page 2

    the phone will use a medpro to communicate with the far end instead of communicating directly.
  14. PeteBull

    CM 5.x direct connection to SBC?

    try this app note... http://support.avaya.com/css/P8/documents/003941272
  15. PeteBull

    Monitoring calls for 'quality assurance'

    Our QA staff usually leaves the QA phone in service observer (on a VDN) overnight and over weekend, and the only issues they have are the size of the wav/mp3 files they have to chop up. I don't think they monitor individual agents in this way though I can't think of any reason why it wouldn't work.
  16. PeteBull

    Inbound CALLER-ID / EC500

    This is usually a restriction of the outbound provider. I have had no luck getting Verizon to allow me to present a caller ID that is not a Verizon-number-assigned-to-my-trunk-group.
  17. PeteBull

    Queue-Fail when agent in ACW?

    I have changed the vector as LoopbackJack suggested and it functions correctly. Thanks LoopbackJack. I am still disappointed that queue-fail only works on attendant vectors.
  18. PeteBull

    Queue-Fail when agent in ACW?

    changed to: display vector 8 Page 1 of 6 CALL VECTOR Number: 8 Name: PAE Queue Fail Multimedia? n Attendant Vectoring? n Meet-me Conf? n Lock? n Basic? y EAS? y...
  19. PeteBull

    Queue-Fail when agent in ACW?

    Here is the vector now. display vector 8 Page 1 of 6 CALL VECTOR Number: 8 Name: PAE Queue Fail Multimedia? n Attendant Vectoring? n Meet-me Conf? n Lock? n Basic? y...

Part and Inventory Search

Back
Top