Posted By: tOoL (~~~~~e~$~0~t~e~r~!~c~~~~~) on 'CZdatabases'
Title:     jeden viceradkovej misto multiple-jednoradkovejch vysledku?!
Date:      Wed Mar  6 23:28:51 2002

sla by nasledujici procedura udelat tak, aby vracela misto 
multiple-jednoradkovejch
vysledku, pouze jeden viceradkovej...?!


declare @nID int
declare cur cursor for select ID from Table open cur fetch from cur into @nID
while @@FETCH_STATUS = 0
begin

  select 1 -- tady chci mit slozitejsi dotaz... pro jednoduchost tam je 1

  fetch next from cur into @nID
end
close cur deallocate cur
 

Search the boards