Using IF ELSE statement based on Count to execute different Insert statements

Question

While I am searching through my database, I run an INSERT statement if I find that a particular item does not exist, and I run a different INSERT statement if I find one or more of this item.

I am not entirely sure how to use the IF ELSE expressions.

What I have so far is a statement that will count the number of times the target data appears; it will print TRUE if it is greater than 0, if not, it will print FALSE. I can't find any examples to help me understand how I can use this to run two different INSERT statements.

Here is what I have so far:

SELECT CASE WHEN COUNT(*)>0 THEN 'TRUE' ELSE 'FALSE' END (   SELECT [Some Column], COUNT(*) TotalCount   FROM INCIDENTS   WHERE [Some Column] = 'Target Data'   GROUP BY [Some Column] ) 

Answer 1

Depending on your needs, here are a couple of ways:

IF EXISTS (SELECT * FROM TABLE WHERE COLUMN = 'SOME VALUE')     --INSERT SOMETHING ELSE     --INSERT SOMETHING ELSE 

Or a bit longer

DECLARE @retVal int  SELECT @retVal = COUNT(*)  FROM TABLE WHERE COLUMN = 'Some Value'  IF (@retVal > 0) BEGIN     --INSERT SOMETHING END ELSE BEGIN     --INSERT SOMETHING ELSE END