|
Posted by CK on 03/09/06 20:01
Sweet! Thanks man.
"figital" <mharen@gmail.com> wrote in message
news:1141927222.299970.274010@i39g2000cwa.googlegroups.com...
> Just one block:
>
> -- get list of taskorders with their respective fundingtotals as of
> specified date
> SELECT TO1.TaskOrderID,
> FROM TaskOrder TO1
> WHERE (@BillingContractID IS NULL OR TO1.BillingContractID =
> @BillingContractID)
> AND (@Filter IS NULL OR TO1.Retired <> @Filter)
>
> Note this last line. If @Filter is NULL, the entire block is ALWAYS
> true so "TO1.Retired <> @Filter" doesn't matter. If @filter is not
> null, "TO1.Retired <> @Filter" is the part that matters.
>
Navigation:
[Reply to this message]
|