The best way to display values from a CURSOR

[lottalava]

Hello folks, it could be very dummy but, how can i display a value from a column inside a CURSOR, i mean, not using print( ).

Regards,
lottalava

[iftikharqamar]

HAY,

When you are reading your cursor, read the value of each column in a variable and when you are into the fetch block, use those variables. Hope following sample code will server your purpose. If not let me know what exactly you are looking.


declare @CurrDate datetime, @firstname varchar(50),@lastname varchar (50)
declare PatientCursor Cursor read_only for
select timestamp,fname,lname from table where order by timestamp asc
open PatientCursor
Fetch next from PatientCursor into @CurrDate, @firstname, @lastname
while (@@fetch_status =0)
Begin
// do with your variables here what you want to do.....for each iteration they have corresponding values...
Fetch next from PatientCursor into @CurrDate, @firstname, @lastname
End

close PatientCursor
deallocate PatientCursor

[ck9663]

Hello folks, it could be very dummy but, how can i display a value from a column inside a CURSOR, i mean, not using print( ).

Regards,
lottalava

what do you mean display? if you just want to see the value, you can do a SELECT @varname. if you want to display it in some GUI, you have to control that in your GUI. it varies depending on your front-end dev tool