DECLARE @CItem NVARCHAR(10)
DECLARE db_cursor CURSOR FOR
select ColName from Table_Name
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @CItem
WHILE @@FETCH_STATUS = 0
BEGIN
--Write your SQL here.
FETCH NEXT FROM db_cursor INTO @CItem
END
CLOSE db_cursor
DEALLOCATE db_cursor
