Yep I want to raise an error. I want to have the system notify me of an error condition if I have NULL values in a table.

Here is test code that I have been playing with for the past few hours:


DECLARE @rows int
--if (
select progeddid
from progedd_pacid
where progeddid is null
--)
--begin

Select @rows = @@ROWCOUNT

if (@rows > 0 )

I want the error to occur here

print @rows
else
print 'none today'
--end

I've tried the if / if exist and still don't have a good return that I can test except for this.

If there are nulls, that means a table was down in DTS import into our DW and I need to know before a user tells me....

TIA

__Stephen