Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ponderena

    Slow Query

    ave a select statement as follows, which runs very slow. I think it is the count or the subselect, but I do not see how I could optimize it. I tried using hints, Ordered and All Rows, but it did not do speed up the retrieval. The tables are indexed. SELECT CASE WHEN (a.type =...
  2. ponderena

    Call Procedure from CASE/WHEN

    Thanks, Dagon, for the example. Ponderena
  3. ponderena

    Call Procedure from CASE/WHEN

    I need to call a procedure from a CASE-WHEN statement, from a script. Is this permissible? I want to do something like: SQL SCRIPT: set autoprint on set linesize 80 set serveroutput on SELECT type, (COUNT(CASE WHEN (called_procedure(field1,field2) = 1) THEN (CASE WHEN...

Part and Inventory Search

Back
Top