• For your dataset query, are you using a text command type or stored procedure?

    EDIT: I should have been more clear. You can set the parameter in the node to not accept nulls and it won't. However, if you're sending this down to a procedure you'll have some extra options available to you.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA