Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: Stored Procedure ( array )

    Hello,
    I have a stored Procedure , that now have a lots of logic and start to be very slow ...

    I have to retreive with a cursor, datas from one table 3 times , in different order.
    There is a way to keep the information in memory and do the sort in memory instead of doing 3 times the SQL ?

    ...like putting this information in an array or something like this ...

    Thank You -

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    start reading from here: Array types
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •