thx for the answer..can i asked u more question.hehe..since im new in sql...thx b4...
how about if i hv 2 loop
while @@fetch_status=0
begin
set y=y+1
set x=0
while @@fetch_status=0
begin
x=y+1
if y = 5
'exit the second do while and back to the first do while -- y=y+1
end
end