How can I add a for loop in the report sql?

(2 posts) (2 voices)

Tags:

No tags yet.

  1. jasmondluk, Member

    How can I add a for loop in the report sql? What is the correct syntax? Thanks

  2. myDBR Team, Key Master

    In general, you try to avoid using loops in SQL procedures as loops serializes the queries.

    If you really need a loop, you can use a cursor or while loop.

    --
    myDBR Team


Reply

You must log in to post.