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