Posted by DickChristoph on 02/27/06 20:44

Hi Edgar,

How about:

Create proc rb_SubledgerRpt
@Acctcode varchar(4), @SubAcct varchar(3)
As
Select AcctCode, SubAcct
From GLDetails
Where SubAcct <> ' '
and ((@AcctCode = '*' ) or (AcctCode = @Acctcode))
and ((@SubAcct = '*' ) or (SubAcct = @SubAcct))

-Dick Christoph
"Edgar" <edgarjtan@yahoo.com> wrote in message
news:1141058639.691125.36720@v46g2000cwv.googlegroups.com...
> Hi,
>
> I need some advise on how to automate record selection on a stored
> proc. Here is my situation. I have a stored proc that I used on
> Crystal reports with two parameters - Acctcode and Subacct. When a
> user enters ' *' on these parameter, it means to report on all
> accounts otherwise, report only on specific account.
>
> Here is my select statement with line numbers:
>
> Create proc rb_SubledgerRpt
> @Acctcode varchar(4), @SubAcct varchar(3)
>
> As
>
> 3 Select AcctCode, SubAcct
> 4 From GLDetails
> 5 Where SubAcct <> ' '
> 6 and AcctCode = @Acctcode -- for specific acctcode
> 7 and SubAcct = @SubAcct -- for specific subacct
>
> 8 Go
>
> -- If a user wants to see all Acctcode, and all Subacct, how do I
> disable lines 6 and 7?
>
> Thank you in advance for your help.
>
> Edgar
>

[Back to original message]