Professional Web Applications Themes

am i in an end-less loop here? - Microsoft SQL / MS SQL Server

Have you tried a set-based solution to this rather than resorting to cursors? This looks like tree manipulation in an adjacency list hierarchy. Have you considered using Nested Sets instead? http://www.intelligententerprise.com/001020/celko1_1.shtml Without DDL and the code for the sched_expand_org function it's difficult to give a more complete answer. I can't see anything obviously wrong with your cursor code apart from the fact that it's *cursor* code. -- David Portas ------------ Please reply only to the newsgroup --...

  1. #1

    Default Re: am i in an end-less loop here?

    Have you tried a set-based solution to this rather than resorting to
    cursors?
    This looks like tree manipulation in an adjacency list hierarchy. Have you
    considered using Nested Sets instead?
    http://www.intelligententerprise.com/001020/celko1_1.shtml

    Without DDL and the code for the sched_expand_org function it's difficult to
    give a more complete answer. I can't see anything obviously wrong with your
    cursor code apart from the fact that it's *cursor* code.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Guest

  2. #2

    Default Re: am i in an end-less loop here?

    Thanks, David. Another headache to look into... ;)

    Alex


    "David Portas" <org> wrote in message
    news:phx.gbl... 
    to 
    your 


    Alex Guest

  3. #3

    Default Re: am i in an end-less loop here?

    As always, I'm grateful Steve.

    Alex

    "Steve Kass" <edu> wrote in message
    news:eQxRDd#phx.gbl... 
    >
    >[/ref]


    Alex Guest

Similar Threads

  1. Loop option set, but flash doesn't loop
    By uj666 in forum Macromedia Flash Player
    Replies: 6
    Last Post: October 21st, 04:23 AM
  2. Can a film loop play once, then loop on the last frame(s)?
    By Schiemer webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 0
    Last Post: November 29th, 03:35 AM
  3. Film loop rollovers working with tell sprite, but only if Loop is checked
    By Schiemer webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 0
    Last Post: November 27th, 06:02 AM
  4. Urgent: Repeat loop and Film loop clash!
    By Jai G in forum Macromedia Director Lingo
    Replies: 4
    Last Post: July 31st, 04:39 AM
  5. Help with loop inside loop and mysql queries
    By Petre Agenbag in forum PHP Development
    Replies: 1
    Last Post: July 16th, 07:36 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139