Any alternative for INLINE SQL QUERY?

srinivas_vja · #1 (**permalink**) 01-25-05, 17:31

Hi

I need alternative solution to INLINE SQL query.

eg.1:

Quote:

select d.deptid, d.deptname,
( select count(empid) from emp e where e.deptid=d.deptid )
from dept d

eg.2:

Quote:

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

Pat Phelan · #2 (**permalink**) 01-25-05, 18:24

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