Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Null report parameter

    This looks like Access code.  In Access you would use:

    nz([Parameters!Status.Value],"") = ""

    You could also use:

    [Parameters!Status.Value] = NULL

     

  • RE: Problem with: Warning: Null Value is eliminated by an aggregate or other SET operation.

    Try this:

    WHERE ((CAST(ISNULL(QuestionNumber,'') AS VarChar) + CAST(ISNULL(Role,'') AS VarChar) + CAST(ISNULL(GroupNumber,'') AS VarChar)) NOT IN

    (SELECT CAST(ISNULL(Question,'') AS VarChar) + CAST(ISNULL(Role,'') AS VarChar) + CAST(ISNULL(GroupId,'') AS VarChar) AS Expr1

    FROM [360_QuestionResults]))

  • RE: formatting numbers

    My front end is Access. If I am displaying the number in a list box I cannot use the formatting capability of Access, I have to use the language...

  • RE: Stored Procedure Replication

    Using Enterprise Manager, right click on the stored procedure, select All Tasks, then General SQL Script. Press OK to create a script file which you can run on another...

Viewing 4 posts - 1 through 4 (of 4 total)