Post reply

Outer Join

  • March 31, 2010 at 10:54 pm

    #386619

    I want to convert this query in to SQL server please

    any one reply me..

    "select bo.agency_no,

    bo.branch_no agency,

    substr(memmgr.F_BranchName(bo.agency_no, bo.branch_no),1,80),

    SERVICE_DETAIL,

    SERVICE_TYPE,

    SERVICE_TIME,

    SERVICE_COST,

    SERVICE_STATUS

    from dolamgr.clientservicelog cslw, memmgr.agency a, memmgr.branchoffice bo

    where cslw.agency_no != mlsmgr.f_instituteagency()

    and cslw.agency_no = bo.agency_no(+)

    and cslw.branch_no = bo.branch_no(+)

    and cslw.agency_no = a.agency_no(+)

    and cslw.service_opdate between :From_Date.dti and :To_Date.dti

    and nvl(service_status,'N') != 'I'

    AND WEB_SERVICE_CODE = 'VGO'

  • March 31, 2010 at 11:03 pm

    #1143680

    Please provide table definitions for the tables involved in this query.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 1, 2010 at 12:33 am

    #1143698

    Provide sample script and data for the same

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply