Loops and conditions

Loops in sql qork with cursors check these links 1.for detailed help coding example is as follows

DECLARE @A varchar(50),@B varchar(50);
 DECLARE @c bigint;
set @c=0
DECLARE contact_cursor CURSOR FOR
SELECT A, B  FROM TABLE_NAME

OPEN contact_cursor;
FETCH NEXT FROM contact_cursor
INTO @A,@B;
WHILE @@FETCH_STATUS = 0
BEGIN
set @c=(select count(b) from table_name where A=@A)
PRINT @A+' | '+ @B+' | '+ @C +' | text. |'
   -- This is executed as long as the previous fetch succeeds.
   FETCH NEXT FROM contact_cursor
  INTO @A,@B;
END
CLOSE contact_cursor;
DEALLOCATE contact_cursor;

for if condition check this link.... example is given bellow

IF condition
BEGIN 
--code
END
ELSE
BEGIN 
--code
END

Thanks abellazm I will give it a try