declare @ssid nvarchar(50) declare cur cursor read_only for select top 1 ssid from ssidinfo open cur
fetch next from cur into @ssid while (@@fetch_status =0) begin print @ssid fetch next from cur into @ssid end close cur deallocate cur