How to check if there are rows and execute an Insert

Question

I got the following SQL Code, I need

Execute an Insert only if the code returns more than 0 rows.
Put messages on the screen for the person who executes the script, saying No missing rows were detected or 3 missing rows were detected and added.

select * from DistributionKey_Section where SectionID not in ( select siteid from Site where SiteTypeCodeID IN(8) ) and DistributionKeyID NOT IN ( select DistributionKeyID from DistributionKey where UnitInclusive=1 )

Matt Klepeis · Accepted Answer · 2011-08-25 08:22:55Z

1

DECLARE
   @MissingRows int,
   @InsertedRows int    

SELECT *
FROM DistributionKey_Section
WHERE SectionID NOT IN ( select siteid from Site where SiteTypeCodeID IN(8) ) AND
      DistributionKeyID NOT IN ( SELECT DistributionKeyID FROM DistributionKey WHERE   
      UnitInclusive=1 )

SET @MissingRows = @@ROWCOUNT     

IF @MissingRows > 0
   BEGIN
   <Insert Statement/Logic>
   SET @InsertedRows = @@ROWCOUNT
   PRINT CAST(@InsertedRows as varchar(5)) + ' missing rows were detected and added'
   IF @MissingRows <> @InsertedRows 
      BEGIN
      RAISERROR('The number of rows inserted does not equal the number of rows missing', 16, 1)
      END
   END
ELSE
   PRINT 'No Missing Rows Detected'

answered Aug 25, 2011 at 8:22

Matt Klepeis

1,7221 gold badge14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Klepeis Over a year ago

This should get you pointed in the right direction. I did not touch the insert as I was unsure of what exactly you wanted inserted and where.

Collectives™ on Stack Overflow

How to check if there are rows and execute an Insert

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related