SELECT 
  * 
FROM 
  (
    SELECT 
      TOP 100 PERCENT CODE STOK_KODU, 
      NAME STOK_ADI, 
      SPECODE STOK_OZELKODU, 
      ISNULL(
        (
          SELECT 
            SUM(ONHAND) 
          FROM 
            LV_101_01_STINVTOT STITOTS WITH(NOLOCK) 
          WHERE 
            STITOTS.STOCKREF = ITEMS.LOGICALREF 
            AND STITOTS.INVENNO = 281
        ), 
        0
      ) STOK_ADET 
    FROM 
      LG_101_ITEMS ITEMS WITH(NOLOCK) 
    WHERE 
      ACTIVE = 0
  ) as TF 
WHERE 
  STOK_ADET > 0