Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: Sybase 10 limitations

    CustID EmaiID
    HK08012698 edxxxxx@gmail.com
    HK08012698 kimxxxx@gmail.com
    HK08012698 yunxxxx@hotmail.com
    HK08012699 sallyxx@gmail.com
    HK08012699 joexxxx@gmail.com
    HK08012697 yangxxx@hotmail.com
    HK08012700 ed1xxxx@gmail.com
    HK08012700 ed2xxxx@gmail.com
    HK08012700 ed3xxxx@gmail.com
    HK08012700 ed4xxxx@gmail.com
    HK08012700 ed5xxxx@gmail.com
    HK08012700 ed6xxxx@gmail.com
    HK08012700 ed7xxxx@gmail.com
    HK08012700 ed8xxxx@gmail.com
    HK08012700 ed9xxxx@gmail.com

    My requirement is to display

    HK08012699 sallyxx@gmail.comsallyxx@gmail.com/joexxxx@gmail.com

    I have written a query which i executed it in 12.0 & 12.5.4
    versions. It was executed successfully. But the same
    query is not giving the expected result in sybase 10. Why ? Inputs are
    welcome !


    Create Procedure Email_ID_display
    (
    @CustID varchar(30)
    )
    as
    Begin

    Declare @Add varchar(255)
    select @Add = ''
    select @Add = @Add +Address + '/'
    from Email_ID
    where CustomerID = @CustID

    select @CustID,substring(@Add,1,len(@Add)-1)
    End

    exec Email_ID_display 'HK08012700'

    HK08012700
    ed1xxxx@gmail.comed1xxxx@gmail.com/e...xxxx@gmail.com

  2. #2
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    Any inputs ?

  3. #3
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Does it give you any errors?

    Sybase 10 is probably 12-15 years old and theres very less chance that someone has it installed for them to try it for you. So, you are pretty much on your own. Try splitting all the individual parts and run it to see whats failing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •