Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Return multiple rows from a cursor with just one fetch

    Try this link, seems to be doing what you want although admittedly I have not had a chance to test it. Syntax goes:

    set cursor rows number for cursor_name

    Link:

    http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/51067;pt=51945

     

     

  • RE: Is it just me...

    Iwould agree that the question is minimal and that the answer options act as clear guidelines as to what is expected. I am not sure I perceive that as a...

  • RE: QOD 9/16/2003

    Yes, I made the same decision. Actually I had 4 ticked and then thought hang on... Shame about the answer it would have been a great trick question.

  • RE: QOD 8/12/03

    My deduction is that the query is assessing the contains condition on all columns seperately and accepting all results where any one column passes.

  • RE: Need help with calculation

    Amended original post to add permnum limitation.

    declare @denom int

    declare @num int

    declare @aver float

    declare myfetch cursor for select permnum, cola, colb, colc, cold from rmx

    declare @myfetch nvarchar(10)

    declare @myfetcha varchar(2)

    declare @myfetchb varchar(2)

    declare...

  • RE: Design Question

    No real difference of opinion from me. I would send it back too primarily because it is sloppy irrespective of whether it is ever going to cause a problem.

Viewing 6 posts - 1 through 6 (of 6 total)