WITH outer_tbl AS (SELECT ROW_NUMBER() OVER (ORDER BY id_obat ) AS  "ZEND_DB_ROWNUM", * FROM (SELECT TOP 10 o.id_obat, o.nm_obat,  o.status_dot, s.nm_satuan, o.hna, (SUM(sd.jml_obat)-ISNULL(b.stok_tgl,  0)) pers, a.bln_lalu, CASE WHEN a.bln_lalu > SUM(sd.jml_obat) THEN  (CASE WHEN a.bln_lalu > sk.stock_max THEN (a.bln_lalu -  SUM(sd.jml_obat)) ELSE (sk.stock_max - SUM(sd.jml_obat)) END) WHEN  a.bln_lalu < SUM(sd.jml_obat) THEN 0 ELSE 0 END AS eoq, (SELECT  SUM(jml_obat) FROM apt_stock_detail WHERE id_obat= o.id_obat AND  id_apotek IN (SELECT id_apotek FROM apt_apotek WHERE id_region IN  (SELECT id_region FROM apt_apotek WHERE id_apoteks = '333000123')) GROUP  BY id_obat) pers_reg, sk.stock_min, sk.stock_max FROM apt_obat o LEFT  JOIN (SELECT obat_id, SUM(obat_do) bln_lalu FROM apt_penjualan_detail  WHERE formid IN (SELECT formid FROM apt_penjualan WHERE id_apotek =  '333000123' AND datepart(m,penjualan_tgl) =  datepart(m,dateadd(m,-1,2012-03-21))) GROUP BY obat_id) a ON o.id_obat =  a.obat_id LEFT JOIN (SELECT obat_id, ISNULL(SUM(obat_do),0) stok_tgl  FROM apt_penjualan_detail WHERE formid IN (SELECT formid FROM  apt_penjualan WHERE id_apotek = '333000123' AND penjualan_tgl >  '2012-03-21') GROUP BY obat_id) b ON o.id_obat = b.obat_id JOIN  apt_satuan s ON o.id_satuan = s.id_satuan JOIN apt_stock_detail sd ON  o.id_obat = sd.id_obat LEFT JOIN apt_stock_ket sk ON  o.id_obat=sk.id_obat WHERE sd.id_apotek = '333000123' GROUP BY  o.id_obat, o.nm_obat, o.status_dot, s.nm_satuan, o.hna, sk.stock_min,  sk.stock_max, a.bln_lalu, b.stok_tgl) AS inner_tbl) SELECT * FROM  outer_tbl WHERE ZEND_DB_ROWNUM BETWEEN 1 AND 10