Viewing 15 posts - 76 through 90 (of 135 total)
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...
April 10, 2006 at 7:33 am
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,...
April 7, 2006 at 12:05 pm
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
April 6, 2006 at 12:18 pm
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...
April 6, 2006 at 12:15 pm
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...
April 6, 2006 at 9:41 am
Noel
Your example is what I should have included. I am sorry.
You are correct.
Howard
April 5, 2006 at 4:26 pm
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...
April 5, 2006 at 4:06 pm
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...
March 10, 2006 at 1:41 pm
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...
March 10, 2006 at 12:56 pm
Ray M
You are correct in that there are many records in the non-grouped resultset.
Any suggestions on how to correct this?
Howard
March 10, 2006 at 12:03 pm
Kenneth:
Thank you for the additional information. You have been a great help to me.
Howard
February 8, 2006 at 7:01 am
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...
February 6, 2006 at 8:45 am
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...
February 6, 2006 at 7:51 am
Viewing 15 posts - 76 through 90 (of 135 total)