Robert,
This list is not a general support list for InterBase nor for third-party
products.

Please take your support/syntax questions to the list interbase@...
and keep this and the other "Issues" lists clear for their stated purpose.

To refresh your mind with this list's purpose, please go to
http://www.egroups.com/community/ibdi.

Thank you.

Helen
(as Moderator and in response to complaints from other IBDI members)

-------------------------------------------------------------------------

At 08:17 PM 31-10-00 -0500, you wrote:

>Hi:
>
> I am running below statement, iterating through each month 1-12.
>
>SELECT ASSOCID,
>
> ((SELECT COUNT (A1.ASSOCID)
> FROM ASSOC_C A1
> WHERE (A1.INITL_DATE <= :CutDate)) -
>
> (SELECT COUNT (A2.ASSOCID)
> FROM ASSOC_C A2
> WHERE (A2.CANCL_DATE < :CutDate))) AS NetMembers
>
>FROM ASSOC_C A0
>WHERE A0.ASSOCID = :CONTROLID AND A0.ID = :ID;
>
> Would there be any advantage to put this into a stored procedure
>and call it 12 times to get the same data?
>
>Thanks.
>
> Best regards
>
>Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
>Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________