Loops and conditions

[bahed121]

Hey all,

Can any when tell me how to loop and put if-conditions in sql query? as I am new in SQL i am a bit confused about this please help me i have very short time.

Thanks in Advance

[abelLazm]

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

[bahed121]

Thanks abellazm I will give it a try