Hi,

Im sorry if this is trivial, but I am still learning the ropes and apologise.

I have a stored procedure which contains the following script:-

BEGIN
IF @OUID=0 OR @RelatedOUID=0
PRINT 'UNABLE TO FIND OUID'

-- get next record using the cursor
FETCH NEXT FROM CursorToProcessRecords INTO
    @OUID
, @RelatedOUID

IF @OUID>0 AND @RelatedOUID>0
IF @DEBUG=1 PRINT @OUID

INSERT VALUES...

I am testing the stored procedure with only 3 accounts where I know there are no values for @OUID and @RelatedOUID, the stored procedure does not print the 'UNABLE TO FIND OUID' but instead try's to process the record (Insert) thus causing errors when Inserting rather than moving on to the next record.

Any insight would be greatly appreciated.

Regards
Dwizz

When you say you see ERRORs, what is that you see? Without posting the errors here we will have no clue on what you are missing. We shall just go on guesses.

Is that you have OUID and RelatedOUID as NULL in the database? If so you got to check for NULL and not for ZERO.

IF @OUID=0 OR @RelatedOUID=0 -- will become
IF @OUID IS NULL OR OUID = 0 OR @RelatedOUID IS NULL OR @RelatedOUID = 0

Hope that helps.
Cheers.

_________________________
- Vijay G
Strive for Perfection

Thanks Vijay,

That has produced the output I expected, and stopped the error messages which were related to Null values

Regards
Dwizz

You can still simplify it using...
_________________________
- Vijay G
Strive for Perfection

Thanks again Vijay,

I tried the simplified way and that worked too with the same results

Dwizz