Forum Replies Created

Viewing 15 posts - 76 through 90 (of 135 total)

  • RE: Query puzzle

    Noel:

    I have tested all variations that I can think of and your query appears to catch all situations.

    I really do appreciate the help on this one. I would have never...

  • RE: Query puzzle

    Noel:

    I believe that there is one problem with the query. In the example below the error with the first entry being an 'E' without a preceeding 'B' is not caught.

    Also,...

  • RE: Query puzzle

    Noel:

    Thank you for taking my question a step further and giving me a more detailed result.

    I am sorry for the poorly worded question and I thank you for your help.

    Howard

  • RE: Query puzzle

    Ryan:

    You gave me exactly what I was trying to ask for. I am very sorry for the poor wording in my original question. You are exactly correct in that if...

  • RE: Query puzzle

    Ryan:

    Thank you for your response. I got your query to execute without a problem however it does not give me what I need.

    If possible I would like to not...

  • RE: Query puzzle

    Noel

    Your example is what I should have included. I am sorry.

    You are correct.

    Howard

  • RE: Query puzzle

    I am sorry but I did not show the Sequence_Number column in my example. If you order by Sequence_Number the rows will be returned in the proper order.

    What do you...

  • RE: Query puzzle

    The results should be ordered by sequence_number.

  • RE: Incorrect amount returned in ''''having'''' statement

    paramind

    Thank you, thank you, and thank you.

    Your example is exactly what I was looking for.

    The Fund referred to in the query refers to funds for a non-profit community center. Fund 01...

  • RE: Incorrect amount returned in ''''having'''' statement

    paramind

    Thank you, your solution works. Now my problem is that the total of the items returned that equal zero and do not equal zero are not the total rows in the...

  • RE: Incorrect amount returned in ''''having'''' statement

    Ray M

    You are correct in that there are many records in the non-grouped resultset.

    Any suggestions on how to correct this?

    Howard

  • RE: Help with query.

    Kenneth:

    Thank you for the additional information. You have been a great help to me.

    Howard

  • RE: Help with query.

    Kenneth:

    Thank you very much for the help.

  • RE: Help with query.

    Kenneth:

    Thanks, this is the answer that I was looking for. I had forgotten about using the having clause.

    If I may I would like to ask one more question concerning another...

  • RE: Help with query.

    Just for a better understanding of how things work could you modify your query below and add the clause 'where cnt > 0'

     

    --for all rows in TableA regardless of

    --matching...

Viewing 15 posts - 76 through 90 (of 135 total)