Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    India
    Posts
    15

    Question Unanswered: Any alternative for INLINE SQL QUERY?

    Hi

    I need alternative solution to INLINE SQL query.

    eg.1:
    select d.deptid, d.deptname,
    ( select count(empid) from emp e where e.deptid=d.deptid )
    from dept d
    eg.2:
    select dept, count(*)
    from
    (
    select dept,1 as cnt
    from testtable
    group by req,seq,item, dept
    ) XX
    group by dept
    The solution can be a nested query or any other alternative preferably without cursors.

    TIA
    Srinivas

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Why do you need it? If we don't understand what you are trying to do or avoid, odds are good that we'll give you a useless answer.

    -PatP

Posting Permissions

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