Database

SELECT cust_order.order_id     AS order_id
     , customers.fname         AS fname
     , customers.lname         AS lname
     , cust_order.order_date   AS order_date
     , cust_order.order_status AS order_status
FROM   cust_order, customers 
WHERE  cust_order.customer_id=customers.customer_id 
    ?  cust_order.order_id    IN (SELECT DISTINCT order_id
                                  FROM cust_debit 
                                  WHERE amount>=2000) 
  AND  cust_order.customer_id=customers.customer_id 
  AND  cust_order.customer_id IN (SELECT DISTINCT customer_id 
                                  FROM cust_order
                                  WHERE order_id IN (SELECT DISTINCT order_id
                                                     FROM cust_debit 
                                                     WHERE amount>=2000)?;

Create in-memory table

While length of your string > 0

  Get the first part of the string (up to the ,) and insert this into your in-memory table.
  Remove the first part of the string from the string (including the comma)

End while

select from your table where the users are in the in-memory table.

SwatCats wrote:

Can anyone throw somelight on how efficient I can tune this sp??

Dr.PHP wrote:

But i can add timestamp field if u have any solution with it

if @v = '@p5'
Begin
    --Use @p5 variable here
End

declare @p1 nvarchar(20)

@declare @first_name nvarchar(20)

switch( @v )
{
  case '@p1' : @p1
  case '@p2' : @p2
  case '@p3' : @p3
  ...
  case '@p30' : @p30
  default NULL
}

void initialize()
{ p_val(1)= @p1;  p_val(2)= @p2; ... 
  p_ndx(1)='@p1'; p_ndx(2)='@p2' ...
}

variant get_p_value( string p_name )
{ int curr_ndx = 1;
  while( p_ndx( curr_ndx ) <> p_name ) curr_ndx++;
  return p_val( curr_ndx );
}

return_value = eval( @v );

SELECT val FROM myTable WHERE name=@v;

mindgameny wrote:

a sequence number will fill up the id column