Search:

Type: Posts; User: DNance; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds; generated 57 minute(s) ago.

  1. Thread: Join question

    by DNance
    Replies
    1
    Views
    315

    where is s1_contract in the SQL? Maybe share the...

    where is s1_contract in the SQL? Maybe share the rest of the query and we can help out.
  2. I think you want MAX(transaction_Date) that is...

    I think you want MAX(transaction_Date) that is less than. Try a sub-select to get that, instead of explicit inner join
  3. Do you have an index created on trigger_ID?

    Do you have an index created on trigger_ID?
  4. Probably better suited for design forum. My first...

    Probably better suited for design forum. My first 2 thoughts are a separate table for each or a country code identifier in the table as well.
  5. Also, I didn't notice until after reviewing the...

    Also, I didn't notice until after reviewing the above. Where is the join to this X table? "BI_SalesPrice AS x"
  6. since its already a correlated subquery, try...

    since its already a correlated subquery, try using NOT EXISTS and get rid of the DISTINCT in the select clause.



    AND i2.[Variant Code] NOT exists (
    SELECT 1 FROM BI_SalesPrice AS x
    WHERE...
  7. Replies
    2
    Views
    473

    wouldn't casting/converting to BIGINT/CHAR do the...

    wouldn't casting/converting to BIGINT/CHAR do the same? Think with CHAR it may put leading 0's, but you can strip them out.
  8. Replies
    2
    Views
    696

    The SQL you write for the users within your...

    The SQL you write for the users within your application will determine how much of the child data is returned. As far as being slow, have you reviewed the access path to determine if it is making...
  9. Been quite awhile since I had to do this on LUW,...

    Been quite awhile since I had to do this on LUW, but isn't that what GET SNAPSHOT and DB2TOP are for?
  10. Replies
    3
    Views
    348

    how about a little more info? What is your table...

    how about a little more info? What is your table definition? What do you mean by junk? and What are you expecting to have?
  11. Replies
    5
    Views
    279

    except for the fact that it is disparate data and...

    except for the fact that it is disparate data and may not have a key to join on and what would be done with the data that has no corresponding in the first table? The only way to get this in a single...
  12. Replies
    5
    Views
    279

    yes, it does. And, as I mentioned previously, you...

    yes, it does. And, as I mentioned previously, you can do so with the use of UNION. Take a look at it. As already, mentioned you will have to change your select statement so that you have the same...
  13. Replies
    2
    Views
    2,327

    great. What have you so far written? We can give...

    great. What have you so far written? We can give you some tips on how to correct it, if its not giving you exactly what you need.
  14. Replies
    5
    Views
    279

    you can use UNION to put disparate data together,...

    you can use UNION to put disparate data together, but the number of columns and the datatypes have to be the same for each column in order of selection.
  15. Thread: Shared key

    by DNance
    Replies
    3
    Views
    587

    still don't see a question here. I have one...

    still don't see a question here. I have one though. Looking at your diagram, why would you have an id for all three choice tables? I would go with the one key and use the same key in all three tables.
  16. Replies
    1
    Views
    1,066

    I've always liked keeping history in tact within...

    I've always liked keeping history in tact within the current structure, such as an end date for the current row. You can store insert and update userid columns if you want to see who did what. This...
  17. Replies
    2
    Views
    313

    ragursru1983, You opened three separate...

    ragursru1983,
    You opened three separate threads for your single problem. Plus posted the question in other sites. As Mor has told you in all three of your threads here, you do not provide enough...
  18. Replies
    4
    Views
    714

    Pretty sure with what you gave us above the...

    Pretty sure with what you gave us above the answer is on page 173.

    If you really want help give us some additional info one AND condition from the query just doesn't cut it. need the query,...
  19. Replies
    4
    Views
    613

    Maybe not a good idea to have RI on a set like...

    Maybe not a good idea to have RI on a set like that. You could enforce it programmatically. Then on some type of scheduled basis do a REORG with discard, where this key is not in the parent?
  20. Replies
    4
    Views
    613

    do you have indexes that exactly match the...

    do you have indexes that exactly match the defined key? That is the typical problem when someone is having an issue with a cascading delete.
  21. Replies
    1
    Views
    2,693

    what have you tried writing thus far? Its a...

    what have you tried writing thus far? Its a fairly simple query. Just this forum is here to help you with issues, not to do the job for you. There is another forum here on the site, where you can...
  22. Replies
    9
    Views
    431

    Yes, you would convert the one from the table you...

    Yes, you would convert the one from the table you access first on the join condition, so that you can still get index access on the other.
  23. One thing that might be causing this is putting...

    One thing that might be causing this is putting predicates in the wrong place and you might as well write the outer joins more efficiently as well. If you are using explicit join syntax, then put all...
  24. Thread: Hii all

    by DNance
    Replies
    2
    Views
    211

    what is ? Do you have a 32K BP?

    what is ? Do you have a 32K BP?
  25. Replies
    2
    Views
    247

    Actually, GROUP BY can some times avoid a SORT(if...

    Actually, GROUP BY can some times avoid a SORT(if there is an index that supports the grouping), whereas, a DISTINCT will always perform a SORT.
Results 1 to 25 of 158
Page 1 of 7 1 2 3 4