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!

  • Congratulations Andrzejek 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: *

  • Users: daddypost
  • Order by date
  1. daddypost

    Need to use a field from one table in the where clause of another tabl

    That got it. Thank you so much. I was leaving out the initial select and the extra set of ''. That is exactly what I needed. Once again, you are major help and a wonderful source of knowledge. I will again give you star. I have a feeling you might have a few of those in your profile. HA...
  2. daddypost

    Need to use a field from one table in the where clause of another tabl

    thank you for the insight. If we take cold fusion out of it and just wanted to run in pl/sql developer to get a list, is there a way to do it without running a procedure and just from a straight sql statement? Thank you again for taking the time to help.
  3. daddypost

    Need to use a field from one table in the where clause of another tabl

    I was hoping to just run it as a stand alone sql statement in pl/sql developer. The ultimate goal is to have the sql script be used in a cold fusion process that displays all of the items. If I put it into a procedure I guess I can put the results in a variable and then call the variable in the...
  4. daddypost

    Need to use a field from one table in the where clause of another tabl

    I have a table promotion_schedule that has a field called "where clause". This actually has the where clause used to pull certain items out of another table. If I do a: select where_clause from promotion_schedule it will give me the following: ((acntv.master_sku.retail_cat='some...
  5. daddypost

    How to tell a cursor how to pull a specific record

    It would still return null. The initial portion of the cursor should only provide items that are within +-1 of the passed size requested.
  6. daddypost

    How to tell a cursor how to pull a specific record

    Dagon, I'm sorry, I just got back in the office. If a 5 was passed and the only thing was a 3, we would want to pass a Null value. KKBrwnDBA, That makes sense, in theory, however, putting that in practice is something I've never done, nor know where to begin :( Thank you all again for your help.
  7. daddypost

    How to tell a cursor how to pull a specific record

    The cursor should be pulling anything that is within 1 size up or down of the passed parameter size. That could include a full size or a half size up or down. The next closest size could be the full size(if thats the only one available) but it could be a half size as well. If I passed a size...
  8. daddypost

    How to tell a cursor how to pull a specific record

    To point 1, if there is more than 1 size available, then the next smallest size. If there is only 1 size available, then doesn't matter if larger or smaller. To point 2, if there is only one result from the cursor, then null, if more than 1 then it will return the next closest size on the...
  9. daddypost

    How to tell a cursor how to pull a specific record

    I have a cursor that pulls product_id and size and orders them by size asc. I'm passing a size and number(either 1 or 2) to the function. basically what I'm needing to do is return the size that is the next closest to the size I pass in. The issue becomes when I have more than 1 size...
  10. daddypost

    Help speeding up a function

    Jimirvine, I hope something like that can work. Let me provide some examples and see if I can make sense of it. MASTER SKU TABLE master_id ABC123 FGH567 XYZ890 Ensembles_prod_rec TABLE master_id1 master_id2 score ABC123 acbde1 .33 ABC123...
  11. daddypost

    Help speeding up a function

    Dagon, I'm not sure I follow completely. Would I need to manually create the "insert into ordered_row values (1, 'X1', 1);" the tables I am using will be truncated and repopulated daily based on a number of criteria. So everyday, the master_ids will change, as will the items I am joining with...
  12. daddypost

    Help speeding up a function

    This does speed it up a little, thank you. I'm still thinking it shouldn't take this long. Still 100 rows/45 sec. Using the function you provided above the whole sql query is: select m.master_id, customers_x(m.master_id,m.product_id,1), customers_x(m.master_id,m.product_id,2)...
  13. daddypost

    Help speeding up a function

    I have a sql query that pulls about 26000 rows in about 3 min. I have added another column that calls a pretty simple function, but it changes the efficiency to about 100 rows/2 minutes. I really need to add three columns using the same function, but at this rate, it would run all day. The...
  14. daddypost

    Syntax for calling a function inside a function

    i agree whole heartedly. It is done. :)
  15. daddypost

    Syntax for calling a function inside a function

    Thank you so much. Worked like a charm.
  16. daddypost

    Syntax for calling a function inside a function

    I have a function that has three parameters(v-mid,P_product_id, n). Inside that function I need to call another function called top_related_prod_type2 that have the same three parameters that were passed to the main function. The synatx around it looks like this: if v_no_of_records < n then...
  17. daddypost

    looping nested cursors?

    Also, if I pull out the insert statement and run it outside the procedure replacing the parameters with values, it runs fine. So I'm thinking the v_clause is the issue somehow.
  18. daddypost

    looping nested cursors?

    I don't know if you saw the post I just sent out. If you did, I'm not sure what else I can tell you. The to_char(iss.where_statement) is to convert from a CLOB.
  19. daddypost

    looping nested cursors?

    Here are the two procedure I have currently. create or replace procedure test_dynamic_procedure is begin DECLARE CURSOR ao_cur IS select pg.id,to_char(iss.where_statement) where_clause from report.product_group pg, report.intelligent_shops iss where pg.id=iss.group_id and...
  20. daddypost

    looping nested cursors?

    Okay, I'm in a major crunch here. Here's what I have. There is a gui that allows users to select filter criteria. Each product group can have multiple groups with individual filters in it (ie. Gold month could have a gold rings shop,a gold necklace shop, etc each with their own filters)...

Part and Inventory Search

Back
Top