Viewing 4 posts - 1 through 4 (of 4 total)
This looks like Access code. In Access you would use:
nz([Parameters!Status.Value],"") = ""
You could also use:
[Parameters!Status.Value] = NULL
September 28, 2004 at 6:37 am
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]))
June 2, 2004 at 6:26 am
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...
October 28, 2003 at 6:28 am
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...
September 18, 2003 at 6:25 am
Viewing 4 posts - 1 through 4 (of 4 total)